If this change not break the old style is fine, but "standar sql" in fox? so what about occurs()? alltrim()? and MyFunction()?, exist a lot of vfp-things that break the "standar". Anyway, is hard to tell that any database vendor really implement the complete sql-92 sta (the only i know is borland with interbase) and anyway is best use the optimal ways for tunning...

But putting the sql-server behavior is not sense...why if we have a list of 50 fields in a table we must put ALL fields in group by? The sql way is group by ALL fields, its ilogical, if we have a tree-data stored like planets/continents/country/citys is not sense group by all if we really need group by ONLY city...ok, put max( can solve somes querys but really is still ilogical (i don't need the max value in a list where all values are equal, so wasted processing here)