I have a list of job titles and SOME of them have notes in parentheses, like this: Director (Part Time).
I want to write a query that produces the titles without the notes. In other words, all text after the ( would NOT appear. Titles without the ( would display the entire title.
I tried but to no avail.
Help?
Thanks
I want to write a query that produces the titles without the notes. In other words, all text after the ( would NOT appear. Titles without the ( would display the entire title.
I tried but to no avail.
Help?
Thanks