There is no build-in function in SQL server to aggregate strings. If you cannot shift the logic to your presentation layer, where it naturally belongs btw, then I suggest you do some reading on how to aggregate strings in SQL server. For example here on Code Project:
String Aggregation in the World of SQL Server[
^].
Be warned though, there is no nice or elegant solution!