SQL query to featch numeric data from a alpha numeric data column

January 31, 2007 10:04am CST
I have a specific requirement. Lets say I have a Table with the table name EMPLOYEE. Its sturcture is EMP_NO Varchar2(20), EMP_NAME Varchar2(30), EMP_SAL Number(8,2), Lets say the data is as follows EMP_NO EMP_NAME EMP_SAL ``````````````````````````````````````````````` ABC100 ANIL KUMAR 5000.00 XYZ220 Chaitanya R 8000.00 110022 Murali CH 9000.00 345629 Surender R 9000.00 I would like to write a query which will give me the details of the employees whose employee number is actualy numeric. Can any one help.........
No responses