>Thanks for the input...i'm not sure if really work in any situation but at least look more easy than my solution ;) (and work for now)
>
>Is a sad new that VFP 8 lower your group by construct to sql server :(, this can break a lot of good querys..if we upgrade, but because we never use again the vfp database so ok. The only thing that must be equal or least similar is the stability...

Mario,

VFP8 will not breake any "good" queries only ambiguous once.