Curt,

It's documented in VFP8 help under Behavior Changes Since Visual FoxPro 7.0 and INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 mskb #813361.

>Has anyone encountered errors when converting from Fox5 to Fox8 concerning macro substitution within SQL statments. I am recieving error "Group by clause is missing or invalid" from Fox8 but Fox5 runs perfectly. I have narrowed it down to the macro substitution elements within the statement. I was curious to find out if anyone else may have encountered this problem.
>
>Thanks in advance,