RE: Case insensative select using Oracle

[Dennis Benfante <dennis.benfante@wcom.com>]

try converting both fields to uppercase (upper), or lowercase (lower)

String    searchstring = "XYZabc"

String    searchquery = "select *" +
				" from table_name" +
				" where upper(column_name) = upper('%" + searchstring + "%')";

results in -> select * from table_name where upper(column_name) =
upper('%XYZabc%')

Thank you,
Dennis Benfante
WorldCom
E-Commerce and Order Management
Phone: 770-284-4741
V-net: 949-4741
AIM  : dcbenfante


-----Original Message-----
From: Tom Elrod [mailto:telrod@e2technologies.net]
Sent: Tuesday, June 05, 2001 4:58 PM
To: AJUG
Subject: Case insensative select using Oracle


Just wondering if anyone knows how to make a make a SQL select call where
the
search (WHERE value) is case insensitive using JDBC against an Oracle
database.

Thanks.

-Tom