Hi All
I would like to know how to isolate cetain text within a long string. e.g. If my full field is:
"CHEQUE DEPOSIT J C BLOGGS BAWGE123"
All I need to isolate in the query is the "BA" and the characters after that. All of our references start with a "BA" and the remaining is a definate 6 or 7 characters.
I.E. what I need is only the "BAWGE123"
Any ideas?
thanks,
Paul
I would like to know how to isolate cetain text within a long string. e.g. If my full field is:
"CHEQUE DEPOSIT J C BLOGGS BAWGE123"
All I need to isolate in the query is the "BA" and the characters after that. All of our references start with a "BA" and the remaining is a definate 6 or 7 characters.
I.E. what I need is only the "BAWGE123"
Any ideas?
thanks,
Paul