COnvert Access LIKE to TSQL

Transact-SQL
1

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

2

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

2 Likes
3
4

Thanks @ScottPletcher. It works perfectly.