Jeff,

See VFP8 Help Behavior Changes Since Visual FoxPro 7.0 and mskb #813361 SQL SELECT Behavior Changes in Visual FoxPro 8.0.

>I am in process of upgrading to VFP 8, and having good luck except most of my queries that use a Group By clause are reporting errors. I remember reading some threads that talked about not using GROUP BY 1 so I have tried to be good and use only field names but I am still having problems. What has changed where the following query will work?
>
>
>

>Select MainItem, ;
>       RecordNum ;
>  From curTemp ;
>  Group By MainItem ;
>  Order By RecordNum
>  Into Cursor curMainItems
>