I have a field that I need to interrogate.
If it contains a certain string then it needs to do a 'textbetween' function on 2 characters, if it contains a different string then it does a 'textbetween' on 2 other characters.
logically I want to say:
if field TEXTCOL LIKE '%changed the field% then do this
else if field TEXTCOL LIKE '%user-defined%' then do that.
...if that makes sense...
thank in advance,
Matt
