Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to do case insensitive text literal comparison?

Re: how to do case insensitive text literal comparison?

From: <bonanos_at_yahoo.com>
Date: 1998/10/23
Message-ID: <70pqmo$5vd$1@nnrp1.dejanews.com>#1/1

  "mdr" <resnimi_at_mail.northgrum.com> wrote:
> Try the SELECT... WHERE UPPER(COLUMN1) = 'A'

The only problem with that is that if there is an index on COLUMN1 it will invalidate it and cause a full table scan.

An option is to automatically change all values inserted into COLUMN1 to uppercase.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 23 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US