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