Hello I have a table called test1 in DB2 database, in this table there is column name type1 which is 2 char in lenght, I want to write a SQL statement where i want to select all the records where "type1 does not have any numeric data" for example if following is data in type1 column AB CA AA 12 23 A3
then this sql statment must select only AB, CA and AA and ignore 12,23,A3 because there is a numeric data in any field Ashish __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
