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