Hi Doug,

>Why does the GROUP BY statement not function when I include more than one fieldname/columname? For example, this works:
>SELECT category FROM test GROUP BY category
>But this does not:
>SELECT category,id FROM test GROUP BY category
>This is only a problem in VFP 8.0. Version 6 works fine.
>Thanks

It isn't problem. VFP8 is more compatible with SQL. You can to use SET ENGINEBEHAVIOR command to make equal previous version.