title: Print SQL results on separate lines
body: <p>Please see the SQL statement below:</p>
  
  <pre><code>create table dbo.test(id int identity, Name varchar(10))
   insert into test values ('ian')
   insert into test values ('andy')
   insert into test values ('vicky')
  
  SELECT TOP 1
         STUFF((SELECT ',' + Name AS [text()]
                  FROM dbo.Test 
                 ORDER BY id
                   FOR XML PATH('')), 1, 0, '' ) Concatenated
   FROM TEST
  </code></pre>
  
  <p>It returns a single string value: <code>,ian,andy,vicky</code> as expected. If I print the result on a webpage it prints: ian,andy,vicky as expected.  Is there any way it can print:</p>
  
  <p>ian<br>
  andy<br>
  vicky</p>
  
  <p>i.e. on separate lines?</p>