Hmm. It doesn't sound like you need to so anything in SQL here. Why don't you handle this in whichever application generated the query? There is no easy way to turn a result set into a single record without some programming logic. You could do it in a Stored Procedure, by iterating though your results set to generate another one by concatenating the results.