>I am converting some VFP6 SQL to VFL9. Each SQL that has a GROUP BY I am adding an aggregate function to each column in the SELECT that is not in the GROUP BY. On of the columns is a memo field. What aggregate can I perform on a memofield? Or, if there are no aggregates on memo fields ... I really do not even need the memo field values, but I need a memo field in my resulting cursor.
>

You can use new CAST() function to add a memo field to the result

SELECT ... CAST(SPACE(0) AS Memo) AS mymemo ...