Re: how to ignore case under Oracle?

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 Mon Jun 21 1999 - 15:16:56 CDT