>>>Hello,
>>>
>>>was there not a SET() command to ignore the case in SQL statments, so I don't need to
>>>
>>>WHERE UPPER(Lastname) = "TEST"
>>>
>>>In a query on a VFP table?
>>
>>
>>SET COLLATE to "GENERAL"
>>
>>Be aware of index collation sequence for rushmore optimization.
>
>Hmmm. From VFP Help
>SET COLLATE to "GENERAL" - Only for English, French, German, Modern Spanish, Portuguese, and other Western European languages :o(((
The "other" would cover Brezhoneg, Catalan, Irish, Romansch, Cymraeg and others I can't even spell.
>Who are the Western European languages? ;o)))
The general languages.
The rest of the world speaks particular languages.