Re: HELP - CASE SENSITIVITY

From: Bert Scalzo <bscalz01_at_7-11.com>
Date: Fri, 19 Jun 1998 14:58:11 -0500
Message-ID: <6meg3b$hu$1@news.ses.cio.eds.com>

There are some workarounds, a few are:

force data to be stored in uppercase and query as

col = upper(search_value)

2. store data as entered (mixed case) and query as

upper(col) = upper(search_value)

3. store data as entered (mixed case) and query as

            upper(col) = upper(search_value) and
            col like upper(substr(search_value,1,1)||'%'

This last method makes use of several Oracle tricks (i.e. optimizer evaluation precedence ordering and leading edge of index with like clauses). Received on Fri Jun 19 1998 - 14:58:11 CDT