>thanks Naomi i was just wondering if there was simply another alternative to the 'list' function that would store the info into a variable - something like "List all name for ex2s>0 to N
>I suppose -- set alte to n.txt -- List all name for ex2s>0 --- would do it. (with proper syntax of course)
>
>k

In VFP there is no simple way to include a list of all values for a group as a single column. We can use UDF, but it's not simple and simpler to use scan / endscan and other mechanisms.

In SQL 2005 and up it's very easy with FOR XML PATH('') syntax.