Re: Case insensitive select statement?

From: Gary <garygfx_at_hotmail.com>
Date: Fri, 1 Sep 2000 09:25:56 +0100
Message-ID: <8onp3e$6ko$1@uranium.btinternet.com>

Very sneaky, Mads. :-) I'm sure that idea will come in handy.

Thanks,
Gary.

Mads S. Larsen <mads_at_syrak.dknospam> wrote in message news:GJBr5.6132$uy1.101655_at_news000.worldonline.dk...
>
> > create index myindex on table1 (LOWER(name))
> >
> > However, Oracle8i Personal (Win98) reports that an index in a function
isn't
> > supported. Perhaps this is a restriction of the Personal edition?
> >
> Could be.. There is always the old "shadow column" approach: Add an extra
> column to store an uppercase version of the text to be searched.
>
> B Rgds
> Mads
>
>
>
Received on Fri Sep 01 2000 - 03:25:56 CDT