Re: oracle case in sensitive

From: Howard J. Rogers <howardjr_at_www.com>
Date: Mon, 8 Jan 2001 17:25:37 +1100
Message-ID: <3a595d5f@news.iprimus.com.au>

select * from users where upper(name)='SUN' will do it.

Regards
HJR <sundarkumar_at_my-deja.com> wrote in message news:93bkfa$rm5$1_at_nnrp1.deja.com...
> Hi Everyone
>
> I want to make oracle case in sensitive. I mean if I fire sql like
>
> select * from users where name='sun';
>
> now it'll basically look for exact match for sun and it will return
> all the matched recordsd...I want all matches like Sun,SUn,SUN etc...
> which does not look for cases.
>
> In SQL Server it's possible to make the value case in sensitive.. Also
> in Sybase...
>
> So How do I it Oracle??? Pls let me know...
>
> My advance thanx for ur solution..
>
> Regds
> Sundar
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Jan 08 2001 - 00:25:37 CST