You got a lot of really good replies, but they all fix the problem on the application side. They're no good to you. Tell your application vendor to go to hell and find another one. They're idiots. --Walt Weaver (who feels obligated to post once every 6 months, mostly in lower case) Bozeman, Montana On 8/8/05, J. Dex <cemail_219@xxxxxxxxxxx> wrote: > We are setting up an application (third-party out-of the-box type) and the > group that is setting it up would like to set it up so that when users > search for records the searches are NOT case sensitive. > Is there an Oracle database setting that would facilitate this? The > application vendor said it is a database issue and has to be set on the > database side. > > _________________________________________________________________ > Don't just search. Find. Check out the new MSN Search! > http://search.msn.click-url.com/go/onm00200636ave/direct/01/ > > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l