Re: Case insensitive selects

From: John Seitz <seitz_at_pobox.com>
Date: Thu, 06 May 1999 02:23:44 GMT
Message-ID: <3730FD72.E6559B3C@pobox.com>

I don't believe that Oracle has that type of switch/parameter. I think Sybase does, but that is a complete other newsgroup.

John

Super Kev wrote:

> I think this has been on the NG recently, and I think I know the answer BUT
> ......
>
> can somebody confirm that there is no instance parameter that can make a
> select statement case insensitive..
>
> e.g select username from employees where username like 'smi%';
>
> to return SMITH, Smithers, sMithereens etc , etc.....
>
> I know I can use upper() and lower() functions ...
>
> Using Oracle8.0.5 on NT
>
> Cheers
>
> Steve Bright
>
> steve.bright_at_capgemini.co.uk
Received on Wed May 05 1999 - 21:23:44 CDT