Not sure what happened when I hit reply but I think I shot a blank email back just a minute ago.
I never had the opportunity to test what I was told. I was given that information by a DBA. I guess he was wrong. If this search is only on a particular field or a set of fields, it should work if you store the data in all upper case or all lower case so when searching for that field convert the search string first to match the case that it is stored in the DB and then perform the search.. That should work for pre V7 versions.. Joe ----- Original Message ---- From: Daniel Bloom <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, December 13, 2006 1:41:05 PM Subject: Re: Q:Oracle 10GR1 case insensitivity SOLVED Joe, what you were told is false. However getting to the correct answers was more interesting and time consuming. In the end, be very very careful, and created case insensitive indices for those fields where you still want to be able to use them. Short answer: I think that going to Remedy V7 and the new FTS is a better answer. ... Daniel ____________________________________________________________________________________ Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
