And it won't work (by default) in VFP 8.0!

Rick

>>

>>select * from MyTable group by Field1, Field2
>>

>
>This can produce unpredictable results for the fields not included in the GROUP BY clause (for practical purposes: the data will be chosen from an arbitrary record within each group).