Crystal Rouse
asked on
Remove characters at the end of a string.
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 [
Example:
ABC-X-1111 is fine
ABC-X-1111 [aaaa] is not. I need to cut off the [aaaa] at the end of the field.
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 [
Example:
ABC-X-1111 is fine
ABC-X-1111 [aaaa] is not. I need to cut off the [aaaa] at the end of the field.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your answers. This is awesome and I am able to get my update query working correctly.
Open in new window