Oracle is case sensitive and you can't turn it off. You can do
select ... from .. where upper(column1) like 'ABC%'
If you are going to do that I would create a function based index on the
column so the query doesn't do a full table scan. You may or may not be
able to do that depending upon what version of Oracle you have. You don't
indicate.
Jim
<jdoe_at_nospam.com> wrote in message
news:3c1a93b1.27377296_at_news.avnl1.nj.home.com...
> I have an Access database connected to an Oracle back end. How do you
> turn off case sensitivity when running a query? for example, when the
> database was in Access, ABC or abc would return a value, but in Oracle
> ABC and abc are two different search values.
>
> Thank you!!!
Received on Fri Dec 14 2001 - 19:09:05 CST
