Re: how to do case insensitive text literal comparison?

  "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