>Sergey,
>I made a test, but I thing the new way doesnt solve a problem.
>How could I return all the text that a memo field contais if it has a limit of 254 characters to return now ?
>The only way to solve this is get the record and make a new select just to call the memo field with all it contains, right ?
>
>Tia
>
Hi Peter,

The following select will not wor in VFP8 either

SELECT cust_id, contact, count(*) ;
	FROM customer ;
	GROUP BY cust_id

because contact column isn't included in GROUP BY clause as required by ANSI SQL.