>>Hello,
>>
>>I have a SQL Select that does not work. I get "Missing or illegal GROU BY Clause".
>>
>> SELECT F1, F2, F3, F4, F5 ;
>> FROM TAB1 ;
>> INTO TAB2 ;
>> ORDER BY F1, F2, F3, F4 ;
>> GROUP BY F1, F2, F3, F4
>>
>>F5 is a memofield. So I can not include it in the GROUP BY.
>>How can I have the result grouped by the rest of the fields?
>>
>>TIA
>>Gerhard
>Hi Gerhard,
>
>Try SET ENGINEBEHAVIOR 70
>
>Hope this helps,
>
>Ken

No, NO, NO! That's about the worst advice you can give someone. Cyanide is even quicker!

Please read what Help says about Set Enginebehavior, including the warnings!