SQLTeam.com | Weblogs | Forums

Assistance with reg exp

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]%'

2 Likes

No worries I will correct it

Thanks for that.

Cheers