Patrick,

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

>I just recently got a copy of VFP 8.0. I was using VFP 7.0. When I tried running my programs in 8.0 I started getting errors on SQL Select commands where they would run fine in 7.0. First I came accros an error with the Group by clause, Then on another SQL- Select I came by an error 34(Operation is invalid for a memo, General, or picture field).
>
>Has anyone else come accross this problem when upgrading from VFP 7 to VFP 8?
>
>Is there an easy fix for this or will I need to rewrite a lot of my SQL-Select statements?