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 [OT]SQL question
Date Thu, 14 Jul 2005 02:48:43 GMT
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 

Mime
View raw message