SQLTeam.com | Weblogs | Forums

Assistance with reg exp

#1

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!

#2

i think this does the trick...
and eh.FunctionalLoc LIKE '[T,Z]-1[12]%'

thank you all

#3

You don't want the comma, just:

eh.FunctionalLoc LIKE '[TZ]-1[12]%'

2 Likes
#4

No worries I will correct it

Thanks for that.

Cheers