Concatenate output to single column

Last Post 25 Jun 2002 07:59 AM by DTOOKER. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
DTOOKER
New Member
New Member

--
25 Jun 2002 07:59 AM
Hi
Does anyone have a suggestion or know how to take the results of a query, and feed the results into a single column with commas seperating the values? i.e. the result set might be:

Record_Id Description
123 Bug Light
123 Night Light
123 Bright Light

I would want to end up with a single row looking like this:
Record_Id Description
123 Bug Light, Night Light, Bright Light

Thanks for any help
DT
You are not authorized to post a reply.

Acceptable Use Policy