Hi,

If the first character is any character, you don't need to worry about it. Primarily your objective is to ensure that the second character is a number and hence use substr -

SELECT COUNT(*)
FROM t1
WHERE SUBSTR(f1,2,1) BETWEEN 0 AND 9;


Regards,