help with a query

Hi,
I have this select query:
select name from categories
it returns a lot of rows, but I want it to be in a single row separated by ,
so the result would be
"Games, Music, Gifts"
instead of
Games
Music
Gifts
how can I do that?
thanks,
BrunoIt looks like you're looking to do some pivottable stuff. This isn't
trivial to do using TSQL. You'd be better off doing this either on the
client or using MDX expressions.
-Alan|||Look at this example:
http://milambda.blogspot.com/2005/0...s-as-array.html
ML
http://milambda.blogspot.com/