Re: Ignore capitalization in Oracle 8i?

<jdoe_at_nospam.com> wrote in message
news:3c1b2a62.65954517_at_news.avnl1.nj.home.com...
> What is the way to ignore capitalization when doing a query against
> Oracle? I know it can be done because we use a front end system
> (written in VB) that connects to an 8i back end has an option that
> allows you to ignore capitalization when doing a query. Which means
> there is a way to make Oracle ignore case, is it an SQL command?

select ...
from ...
where upper(mycolumn) = 'MYVALUE'; -- or upper(mycolumn) = upper(myparameter)...

>Is it a setting on the database itself?

no

> I'm writing an application that has an Access 2000 front end and an 8i
> back end and the queries appear to be case sensitive.
 

> Note: I previously posted this as "case sensitivity in a parameter
> query" but I didn't give enough information.
>
> Thank you,
> Mike
Received on Sat Dec 15 2001 - 15:58:52 CET