>>>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?
>>
>>There is no such SET() command in VFP. ;o(((
>
>You are right, the SET COLLATE TO did not work. I had to change it into UPPER().
You must match your conditions to your index expressions.