ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Kulkarni <kulkarni_ash1...@yahoo.com>
Subject Re: [OT]SQL question
Date Thu, 14 Jul 2005 10:22:39 GMT
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 <larry.meadors@gmail.com> 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
> <kulkarni_ash1312@yahoo.com> 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 
 

Mime
View raw message