Re: SQL In Java

Cause I didn't know that existed <vbg>
Know I do thanks to you :).

Very big thanks my friend.  You just save some of my hair hehe.


Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
Tel: 709-576-8132
Email: rpower@xxxxxxxxxx
Website: http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. - 
Sir Winston Churchill




Eric Lee <Eric.Lee@xxxxxxxxxxxx> 
Sent by: java400-l-bounces@xxxxxxxxxxxx
2005/06/29 09:42 AM
Please respond to
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


To
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>
cc
"Java Programming on and around the iSeries / AS400" 
<java400-l@xxxxxxxxxxxx>, java400-l-bounces@xxxxxxxxxxxx
Subject
Re: SQL In Java






Ron,

Why don't you just change your statement to account for case?

eg.
select * from table where upper(tabledata) like upper(searchstring)

Eric 




RPower@xxxxxxxxxx 
Sent by: java400-l-bounces@xxxxxxxxxxxx
29/06/2005 10:39
Please respond to
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


To
"Java Programming on and around the iSeries / AS400" 
<java400-l@xxxxxxxxxxxx>
cc

Subject
SQL In Java






Hitting a DB2, and trying to get the SQL statement to ignore the case.  Is 


that possible?

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
Tel: 709-576-8132
Email: rpower@xxxxxxxxxx
Website: http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. - 
Sir Winston Churchill