Brute force? select * from test1 where type1 not like '%1%' and type1 not like '%2%' and type1 not like '%3%' and type1 not like '%4%' and type1 not like '%5%' and type1 not like '%6%' and type1 not like '%7%' and type1 not like '%8%' and type1 not like '%9%' and type1 not like '%0%'
Crude, but effective... Larry On 7/13/05, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: > 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 >
