Vijay,
You can use the UPPER function to convert the selected column to upper case
when searching. However, beware that using the UPPER function will result in
DB2 not using the index on that column and will force a table scan.
Alternatively, you could use a generated column to keep an UPPER copy of the
column and index and search on that column.
Good luck!
>From: Sitaram Vijay kartik <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: DB2EUG: How to make all searches CASE INSENSITIVE
>Date: Fri, 29 Jun 2001 13:21:47 -0700 (PDT)
>
>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
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
