>>>>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!
>
>OK. I should have added a warning to check the help file. But it would work and I don't think it would kill him.
>
>Ken

In some cases he will get the wrong data! Why do you think Microsoft added that command? Again, read Help.