>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.
Dawa Tsering
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature