Re: Case sensitive "like"

From: <shelbyko_at_my-dejanews.com>
Date: Fri, 07 May 1999 15:32:25 GMT
Message-ID: <7gv12a$cmt$1@nnrp1.deja.com>

If you are using sqlplus you can give the command SET SQLCASE MIXED
If you want everything to be converted to lower SET SQLCASE LOWER
similarily SET SQLCASE UPPER.

Shelby
In article <3730CAA4.F05_at_xsoft.demon.co.uk>, gerard <gerard_at_xsoft.demon.co.uk> 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 10:32:25 CDT