Discussion in 'General Developer Questions' started by rmills, Feb 24, 2006.
Is there a way to select all rows where a field is four numeric characters?
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
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.
Separate names with a comma.