SQLTeam.com | Weblogs | Forums

COnvert Access LIKE to TSQL

My Access database uses this:

AND ((Raw.Zone) Like '4##')

As much as I can figure, this is selecting where the column contains a value starting with 4 and is 3 digits long and the 2nd and 3rd characters are numbers/digits.

But I don't know how to doe the same in TSQL. Any ideas please? Thanks

AND ((Raw.Zone) Like '4[0-9][0-9]')

2 Likes

Thanks @ScottPletcher. It works perfectly.