>But FYI: >1) The MEMO in DISTINCT could have been fixed by simply ensuring that ALL fields were compared, INCLUDING memo field content.
It would severly affect query performance. I wouldn't want that.
>2) The GROUP BY could have been fixed by ensuring that all fields INCLUDING inherent "field function" values were properly sourced from the correct record.
Why you want to keep VFP SQL Engine ANSI incompatible is beyond my uderstanding.