Case Insensitive Where statements: Net8?

From: Carole Kaufman <carolek_at_ix.netcom.com>
Date: 9 Apr 2002 12:02:13 -0700
Message-ID: <72330e0d.0204091102.1f4471b0@posting.google.com>

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:02:13 CDT