Hi Dragan
For me the general language is Assembler ;o)))).


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