title: User Defined Function that returns the values of a single column concatenated together
body: <p>I'm using SQL Server 2008 and would like to have a user defined function that concatenates the values of a single column, comma delimited, and returns it.</p>
  
  <p>For example, a table with the following rows:</p>
  
  <pre><code>column1
  ---------
  head
  shoulders
  knees
  toes
  </code></pre>
  
  <p>The function would return the single value: <code>head, shoulders, knees, toes</code></p>