You cannot do this directly. t-SQL resultsets returns tables with rows
having column, with each column representing a single value. So you will
have to hack up some kludge to get this done from the Server. Some such
ideas can be found at:
http://groups.google.com/groups?selm...GP09.phx.g bl

A more reliable approach is to return the resultset to the client
application & format or concatenate the way you want.

--
Anith