Re: how to ignore case under Oracle?

From: Dante <dnotari_at_my-dejanews.com>
Date: Tue, 25 May 1999 10:44:23 GMT
Message-ID: <7iduu7$jrq$1@nnrp1.deja.com>

... and be *very careful* with that ...

functions like upper() or lower() cause the server *not* to use an index which would cause a full table scan. Except ...
if you are using functionbased index in 8i.

Regards
Dante

In article <37478BC2.EAA25665_at_myremarq.com>, Danielle Engel <dogbert_at_myremarq.com> wrote:
> ... where UPPER(a) = UPPER(b)
>
> Jason Coleman wrote:
>
> > Hi all,
> >
> > I'm still pretty new with Oracle. Hoepfully this is a nice basic
> > question. I've primarily dealt with Access and SQL Server so it
hasn't
> > been an issue with me before. How do I do a case insensitive string
> > compare in the WHERE clause under Oracle? I can't seem to find a
mention
> > in the documentation anywhere. All the examples use data which is
all
> > lower case or all uppercase so it never seems to deal with that. I
feel
> > dumb asking, but I've fiddled around with it for enough hours I'm
feeling
> > dumb anyway. :)
> >
> > Thanks!
> > Jason
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 25 1999 - 05:44:23 CDT