oracle case in sensitive

From: <sundarkumar_at_my-deja.com>
Date: Mon, 08 Jan 2001 05:50:35 GMT
Message-ID: <93bkfa$rm5$1@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 Sun Jan 07 2001 - 23:50:35 CST