Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> oracle case in sensitive
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 Sun Jan 07 2001 - 23:52:53 CST