Re: Case Insensitive Where statements: Net8?

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Tue, 09 Apr 2002 19:26:55 GMT
Message-ID: <3CB3407C.E705A77F@exesolutions.com>

Function based indexes in which the values are stored in the index as converting by a function. You can use built-in functions provided by Oracle or functions that you create yourself.

Daniel Morgan

Carole Kaufman wrote:

> In DB2 (sorry....) I can configure the DB2 connect middleware to take
> user parameters in the WHERE and convert them to upper case so the
> query can run efficiently against indexes (all data is in UPPER) and
> accurately as far as the user is concerned. Is there anything in Net8
> / SQLnet configuration that can do the same thing? Is there anything
> that can be turned on via Oracle 9i query re-write that can
> automatically turn predicates into caps?
>
> Thanks for your help,
>
> Carole
> carolek_at_ix.netcom.com
Received on Tue Apr 09 2002 - 14:26:55 CDT