Hi all,
just a quick one.
how could I simplify the below statement into one instead of using the OR.
and (eh.FunctionalLoc LIKE 'Z-1[12]%' or eh.FunctionalLoc LIKE 'T-1[12]%')
any suggestions welcome.
thank you!
Hi all,
just a quick one.
how could I simplify the below statement into one instead of using the OR.
and (eh.FunctionalLoc LIKE 'Z-1[12]%' or eh.FunctionalLoc LIKE 'T-1[12]%')
any suggestions welcome.
thank you!
i think this does the trick...
and eh.FunctionalLoc LIKE '[T,Z]-1[12]%'
thank you all
You don't want the comma, just:
eh.FunctionalLoc LIKE '[TZ]-1[12]%'
No worries I will correct it
Thanks for that.
Cheers