title: SQL Server convert select a column and convert it to a string
body: <p>Is it possible to write a statement that selects a column from a table and converts the results to a string?</p>
  
  <p>Ideally I would want to have comma separated values.</p>
  
  <p>For example, say that the SELECT statement looks something like</p>
  
  <pre><code>SELECT column
  FROM table
  WHERE column&lt;10
  </code></pre>
  
  <p>and the result is a column with values</p>
  
  <pre><code>|column|
  --------
  |  1   |
  |  3   |
  |  5   |
  |  9   |
  </code></pre>
  
  <p>I want as a result the string "1, 3, 5, 9" </p>