>if , not upper should use above then what is the other solution in above case.
John,

Make sure there is an index on the table for UPPER(LastName) and Rushmore will optimize your where clause.

The use fo VFP internal functions in sql has very small costs actually. It is the fact that folks don't create the matching index tags that places the cost.