I stand corrected. That makes a lot of sense for some things, not so much for others. I think what I was thinking is that he meant it's case insensitive and that's that. No options. Obviously there has to be the option in data for case sensitivity and that's what I was getting at.

>MS SQL Server is case insensitive in default installation in regard to data and metadata.
>
>>
>>Well, your last comment sure did open up a can of worms. Case sensitivity in the source code and case sensitivity in the data are two entirely different things. 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. Without case sensitivity on the data, M$ Word couldn't have the feature where it ignores words in all caps during a spell check, assuming that they are acronyms that won't be in a std. dictionary.