TSQL wildcard

[yetanotherjo]

I feel really daft having to ask this, but how do you search using TSQL for numeric values with a wildcard eg. value of Q(number/s) as opposed to Q(char/s)(num/s)?

 

[jrbarnett]

SELECT field
FROM table
WHERE field LIKE 'Q[0-9]%'

will pick up anything starting with Q0 to Q9.

John

 

[yetanotherjo]

Thanks John