>>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(((
Who are the Western European languages? ;o)))
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst