Re: How to make all searches case-insensitive?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 21 Mar 2000 16:57:40 +0100
Message-ID: <953654909.19071.1.pluto.d4ee154e@news.demon.nl>

You can't do this globally.

Regards,

Sybrand Bakker, Oracle DBA

Shmooth <shmooth_at_yahoo.com> wrote in message news:38D78DE5.60D8A2A3_at_yahoo.com...
> I would like all my searches to be case insensitive. Through my app, I
> have:
>
> SELECT Column1 from Table WHERE Column2 = 'some_value'
>
> I want the effect of:
>
> SELECT Column1 from Table WHERE UPPER(Column2) = 'UPPER(some_value)'
>
> I would like to do this globally if possible, as I have lots of code -
> even though
> *most* of the SQL is not hardcoded.
>
> Can I use a trigger, sp?
>
Received on Tue Mar 21 2000 - 09:57:40 CST