>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.
Brandon Harker
Sebae Data Solutions