Good Day Experts!
I have an intriguing request that seems possible to achieve but I am not quite sure how to achieve it.
I have a field in a SQL table called Notes. In Notes, there may or may not be information pertaining to a Department. If appearing the Department will vary in length. Also. there will be varying amount of data in front of the Department. Here is how it will appear in the data:
<Variable amount of text>Department(1)
<Variable amount of text>Department(TG)
<Variable amount of text>Department(456)
I was thinking to work from the end since I cannot be 100% positive the word Department won't appear in the <Variable amount of text>.
How can I work from the end back until the D in Department?