Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Case sensitive "like"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US