>I found in help SET ENGINEBEHAVIOR 70 and it helped me. I use GROUP BY in my SELECT ... VFP 8.0 works in compliance with ANSI.
>thx!
I'm glad SET ENGINEBEHAVIOR 70 resolved your problem. Keep in mind that by using this setting you're giving up on any future changes in Sql Server engine.
--sb--