Determining if a data is an integer or not?

[raghud]

I guess Nandu gave us very good query

SELECT ename FROM Emp
WHERE upper(substr(ename,2,1)) BETWEEN chr(65) and chr(90)

You don't need to mention a..z in query