>>>>>...You have to respect case in the data and VFP does that. All other backends that I am aware of do that, also. I don't know of any data engine that is case insensitive...
>>>>
>>>>I know many:) Hands down.
>>>>
>>>>Cetin
>>>
>>>What I was getting at is engines that are case insensitive 24 hrs a day, 7 days a week, no options. Sergey pointed out that SQL Server is case insensitive using its default installation options, but you can make it case sensitive. So if you need it, you can have it. I was thinking you meant something that was case insensitive and if you want something else, tough! Do you know of any like that? Obviously, with data you have to have case sensitivity at times. Again, this was a different issue than what we were originally discussing and I think we both agree that you have to have case sensitivity in regards to data (maybe not always, but a portion of the data, at least).
>>
>> It is not only SQL server with CI capability, as I said I know more than one.
>>
>>"we both agree that you have to have case sensitivity in regards to data"
>>
>>No you are making assumptions. We do not agree.
>>
>>I knew this was an unnecessary discussion:)
>>Cetin
>
>Ok, Cetin, I think you'll want to restate your position. Explain to me how M$ Word could include a helpful feature like skipping words in ALL CAPS when spell checking if it couldn't look at the data in a case sensitive fashion. No one else here has supported the statement you just made, so I'll make another assumption and assume that you misunderstood what I was saying or perhaps mistated what you were saying.
MS Word is not a database application nor a language. It can even find formatted as arial 10 pt text.
What I am saying I find it nonsense to have case-sensitivity in text fields unless I ask for it. If I need sensitivity or alike I can use binary/nocptrans or specify an option like CS.
Can you even write my name in uppercase? Original lowercase is: çetin - I bet a virtual beer that you can't uppercase it correcly. Why I am saying this? Just to show in a computer language case-sensitivity is important in code but in database I have (should have) to choose it.
Cetin