Re: Oracle Case Insensitivity...

That's the way I read it as well, I just indicated that it is not going to be trivial to add the needed code to reformat the request ( or store all the possible variations in separate fields ..) and expect to be able to use an index as well.. One other way to help the users would be to present them a drop-down list of the values and let them pick what they want without typing..

"Pablo Sanchez" <pablo_at_dev.null> wrote:

>
>"TurkBear" <jgreco1_at_mn.rr.com> wrote in message
>news:dmo2dussk52o8nci12i1f8olqrrn1sldji_at_4ax.com...
>>
>> The definition of 'literal' means EXACTLY , so Memphis and MEMPHIS
>and Memphis are all different values ..
>>
>> The only way to do what you want is to force the data to be stored
>in a pre-determined format ( either by a edit control on a
>> form, or a trigger, or some other pre or post insert method)
>> - that way the where clause can be in the format of the data since
>it will be known..
>
>I'll let the poster answer for hisself but I do believe what s/he is
>intending is to have mix-cased stored in the DB and have the end-user
>type in any string, which will then be matched using an index. Could
>be wrong of course ...

-----------== Posted via Newsfeeds.Com - Uncensored Usenet News ==----------

   http://www.newsfeeds.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Ulimited Fast Downloads - 19 Servers =----- Received on Thu May 02 2002 - 13:10:37 CDT