Re: Case sensitive "like"

From: John Seitz <seitz_at_pobox.com>
Date: Thu, 06 May 1999 02:32:00 GMT
Message-ID: <3730FF63.DDE91BE5@pobox.com>

There is no way of doing this with a parameter or switch. You will have to use upper() to do this. Also in Oracle 8, I think, a column can be a function of a data column. So you could have a function Column with something like this Upper(RealColumn) then do a select on it. But I personally don't like that idea.

john

gerard wrote:

> Hi
>
> Hopefully someone can help
>
> consider "where name like 'fred' . On Access this is case insensitive
> and works well. On Oracle it doesn't.
> I want to avoid using "where lower(name) like 'fred'"
> Is there any way of configuring oracle to always ignore
> case sensitive comparisons.
>
> thanks in anticipation.
>
> gerard heathcote
Received on Wed May 05 1999 - 21:32:00 CDT