Re: oracle case in sensitive

If you want to do it without upper and/or function based indexes, then stick just stick to sqlserver.
The world is case-sensitive, only the evil empire aka Microsoft is not. Seriously, if you don't want to accept the solutions you outlined, there are *no* alternatives.

Regards,

Sybrand Bakker, Oracle DBA

<sundarkumar_at_my-deja.com> wrote in message news:93bkjk$rn0$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...
>
> Without using upper function / Indexing, I want to do it...So How do I
> it in 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:16:27 CST