I need to write a query that will eliminate text to the left of parenthesis and leave just what is in the parenthesis. For example:
Original: ABC Company (Doe, Jane)
Needs to be: (Doe, Jane)
I have numerous companies and the only constant is the information is in parenthesis. I can easily remove this using a “find and replace” in the table but need to be able to do this using a query. I appreciate any assistance – thank-you!