Tamar,

So perhaps we should ask for a RANDOM() function in the next release so that the prior behavior can be formalized. *bg*

>The problem is that when a field is neither aggregated nor grouped, VFP has to choose a value at random to put in the result.
>
>To solve your problem, list only the fields you need (instead of *). Then, for fields other than Name, either add them to the GROUP BY clause or, if the value is the same for each record, wrap them with MIN() or MAX().