Hello this is what i tried select * from test1 where substring(type1,1,1) < '0' and substring(type1,2,1)< '0'
i think it works --- Larry Meadors <[EMAIL PROTECTED]> wrote: > 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 > > > A$HI$H ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs