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