>>I don't think so. With GROUP BY you can combine results from several records in a group, including sums, but I don't think that string concatenation is possible. I suggest you write UDF, which you then invoke from the query.
>
>Thanks for the reply!
>
>
>I didn't expect to have one. Thought, I would pick the brains of VFP gurus. No luck there.
>
>I've resorted to select the records into an array, then the array into a string.

You could also use the "TO MyFile.txt" clause in the SQL and then use FileToStr() to put into a variable.