wildcards in t-sql | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

wildcards in t-sql

Is there a way to select all rows where a field is four numeric characters? Rob Mills
can you give some examples of what constitutes four numeric char, and what does not
do you mean
where field1 like ‘[0-9][0-9][0-9][0-9]’
What is the datatype of that column? If it is not varchar or char, then where col between 1000 and 9999 Madhivanan Failing to plan is Planning to fail
Thanks Twan – that’s what I was looking for. Madhivanan, yes, the column is a varchar type but maybe that would still work. I’ll try it out. Rob Mills