Re: case insensitive search

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Sun, 4 Jul 1999 02:23:00 -0400
Message-ID: <7lmvh1$gmr$2@autumn.news.rcn.net>

Hi,

Others have told you the horrible (from a performance perspective) ways of accomplishing what you want. I have a different approach to your problem. Try:

ALTER TABLE xxx ADD new_col VARCHAR2(nnn);

UPDATE xxx set new_col = UPPER(old_col);

It will cost you disk space but will allow you to use indexing on the VARCHAR2 column in order to realize performance.

regards
Jerry Gitomer

Anurag Minocha wrote in message
<377B7F36.F48D6830_at_synergy-infotech.com>...
>Hi,
>how do i do CaseInsensitive search on varchar2 columns .
>
>anurag
>
>reply at
>anurag_at_synergy-infotech.com
>
Received on Sun Jul 04 1999 - 01:23:00 CDT