>>>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.