title: Concat field value to string in SQL Server
body: <p>I need a similar function to Oracle <code>WM_CONCAT</code> in SQL Server, which returns a comma separated list of whatever field you pass it as argument. For example, in Oracle, </p>
  
  <pre><code>select WM_CONCAT(first_name) from employee where state='CA' 
  </code></pre>
  
  <p>returns "John, Jim, Bob". </p>
  
  <p>How can I do this in SQL Server?</p>
  
  <p>Thanks</p>