>>>Hi Carole,
>>>
>>>I don't have MSDN, so I don't have VFP8. In addition, this SET was not in the VFP8 public beta.
>>>
>>>Can you tell me if this new SET applies only to VFP SQL? By its name, and without other information, it looks like it could apply to all VFP DML commands.
>>
>>Yes, only native selects. I don't think you really use group by in the other DML commands.
>
>Using your logic, I wonder why they didn't call it "SET GROUPBYCOMPATIBILITY...". D'ya think it might be because other stuff is affected too?
>

Well, all the VFP SQL engine changes are grouped into this command. If you read the what's new it lists them. But, (I am pretty sure) they all apply to the SELECT command. Some has to do with grouping, some with using UNION, and a few other issues. (I don't have the release docs with me to double check).

BOb