>>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().
Christian Isberner
Software Consultant