>I am mistaken. Just ran another test, as last night was very late and foggy, and it works just as you have stated. That is actually good. Because now I can change the VFP6 to VFP9 aggregate SQL knowing that the resulting fields that were not aggregates or not in the group by were random (not random, last physical record, but logically random).

Hi Brenda,

You got it. It was the reason all those changes were implemented in VFP8 and VFP9 SQL engine.