Mel,

Here is the thread of interest GROUP BY 1 no longer works Thread #750415 Message #750415

(I searched by 1 as User ID and Select ANSI as keywords)

>>No, unfortunately it's no longer correct way (or never was correct way). It >works in VFP7 and bellow, but would not work in VFP8. It also would not >work in SQL Server or Access.
>
>Thanks for the heads up on this - as I don't want to revisit this code when I move to VF8 in a couple months. In the past I would build a temp unique index to handle this type of situation, and perhaps that is still my best solution.
>
>Mel Cummings