Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: how to ignore case under Oracle?
Only thing to watch out for is that Oracle (as of ver 7, haven't used 8
myself) disables indexes on functions
i.e
select * from my_table where upper(surname) = 'SMITH';
will disable any index on the surname column (I think it also happens if
it's part of a composite index). If it's a problem you could have something
like a SurnameEntered column and a SurnameUpper (which you could use to
search on). You really need to watch out when using the TRUNC function to
strip the time component out of dates that only go in as SYSDATE.
adrien <adrien_at_erols.com> wrote in message
news:376E9DB8.5A042FF4_at_erols.com...
> Convert you strings to upper case : select upper(column_name) from...
>
>
> 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
>
Received on Wed Jun 23 1999 - 16:38:43 CDT