Re: Case Insensitive searches

Craig Burkett wrote:

> Hi all,
>
> I need some guidance as to how best accomplish a case insensitive search
> while still using indexes. One thing I was wondering was does PL/SQL
> support regular expressions and can they be applied to existing indexes.
> I'm trying to avoid having to rebuild indexes forcing them to using upper
> case and I certainly don't want a function (ie UPPER) on the field side of
> the equation which would cause a table scan instead of an index search.
>
> Also does anyone know if Oracle 9i support a switch to use case insensitive
> comparisons?
>
> Thanks,
> --
> Craig Burkett

Your assumption about the UPPER function and indexes is not correct.

Oracle IS case sensitive. Go to http://tahiti.oracle.com and look up function based indexes.

Go to http://asktom.oracle.com and look up case insensitive searches.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)