I need to clean up a database field and remove any characters at the end of the string that start with a bracket [.
The field has values with 10 characters or more. I need to cut off at the end of the string any characters beginning with the [
ABC-X-1111 is fine
ABC-X-1111 [aaaa] is not. I need to cut off the [aaaa] at the end of the field.