I want to select field f1 from table t1.
f1 is varchar(3). The first character is any character and second one must be a number between 0 to 9.
I wrote as follows.
select count(*)
from T1
where f1 like '_[0-9]%';
But it does not work. Is it the correct one..?




Reply With Quote