-
how to write query for getting non numeric values
hii i have a emp table .empno stores all the numeric valuesand accidentally i have added some values with combination of alphabets and special charactersnow i need a query which will return all the records which is having alphabets and characters in their value.assume tht table has records in lakhs.Please answer this questionthankx in advancesreekanth