Full Text Search will also meet your needs. This was reinstated with ARS 7.
-----Original Message----- From: William H. Will Du Chene <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thu, 24 Apr 2008 1:44 pm Subject: Re: Oracle Case insensitive search:any proven easy way? SQL Server is case insensitive by default. With Oracle, you need to perform a linguistic sort. alter session set NLS_SORT=BINARY_CI; alter session set NLS_COMP=LINGUISTIC; > We have implemented Remedy ITSM 7.1 on Oracle. > Customer needs case insensitive searches!! > is there any way other than using ALTER SESSION query,because there is > proven performance impact. > > Best way is to go for SQL SERVER?? > > anyone know about easy way in oracle to make case insensitive > search?anyone > tried in real life?any impact with remedy performance? > -- > View this message in context: > http://www.nabble.com/Oracle-Case-insensitive-search%3Aany-proven-easy-way--tp16851310p16851310.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > -- ------------------------------------- Will Du Chene ------------------------------------- [EMAIL PROTECTED] http://www.myspace.com/wduchene ------------------------------------- "...you're an anti-Microsoft zealot..." - Norm Kaiser ------------------------------------- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"