Vijay;
You can use the UCASE function. Watch out for performance as this will not
be sargable.
Regards,
Scott Saunders
Siebel Systems, Inc.
Opinions expressed are my own and not those of my employer.
-----Original Message-----
From: Sitaram Vijay kartik [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 29, 2001 1:22 PM
To: [EMAIL PROTECTED]
Subject: DB2EUG: How to make all searches CASE INSENSITIVE
Hi,
Is there a way to make the db2 database CASE
INSENSITIVE so that a string like "Evaluation" would
be treated same as "evaluation" or "EVALUATION" or
"EVaLuATIOn".. so on... while searching in SELECT
statements.
Tks in adavce to all!
-- vijay
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
