Re: Text Search Problem

From: <kenhu_at_my-deja.com>
Date: 2000/03/15
Message-ID: <8amq5r$meh$1@nnrp1.deja.com>#1/1

In article <01bf8d3f$3f7dd350$dc000001_at_iwserver>, "Fernando" <Info_at_entelchile.net> wrote:
> I want to search over upper and lower case text indexed columns.
>
> Haw can I do this using the index and avoiding the complete table
search
> that generates "WHERE UPPER(COLUMN) = 'ABCD'"
>
> Thanks
>
> Fernando Seelmann
>

You could de-normalize and use a second column called column_lower and use row level triggers to ensure that all text going into COLUMN is uppercase and all text going into COLUMN_LOWER is lowercase. Then have separate indexes on each.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 15 2000 - 00:00:00 CST