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]’
Twan

---

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

---

]]>