Denis, thank you...that works. I guess I need to go back to school.

Joel

>Hi,
>try
>SET ENGINEBEHAVIOR 70
>
>>I've used the GROUP BY clause thousands of times. Now, all of a sudden in VFP 8.0, I'm getting an error message (Group by clause is missing or invalid) on a simple SQL statement:
>>
>>SELECT item, vendno, mfgbc ;
>> FROM icsupl ;
>> WHERE item = "9999-99-99" ;
>> GROUP BY 2 ;
>> INTO CURSOR xxxxx
>>
>>...will someone tell me what's going on.
>>
>>Joel