I need to compare 2 fields if field 2 is null then look at field 1 (text string) and strip out the end of text where data is within ( ). However the text string can contain multiple sets of parenthesis, I am only interest in the last set at the end of the text string. How do I strip out the data between the Last Parenthesis?
Courses for the Employee (members) Must take (TR1092)
Results should be: TR1092
Note that the length of the data between the last () can vary looking for a function to use with a query..