In VFP 6.0 if I wanted to group by ONE fieldname I would type something like this:
SELECT name_line1, first_name, last_name FROM accounts ;
WHERE NOT EMPTY(last_name) ;
GROUP BY name_line1 ;
ORDER BY last_name INTO ARRAY aClientNames

How do you do it in VFP 8.0?