title: Add selected values from multi column into one column separated by ','
body: <p>I want to select values from multiple columns into one column.  I have 2 separate columns from which i want to get name,address,state,zip in following format in SQL Server 2008</p>
  
  <p>Name (new line)</p>
  
  <pre><code>address,state,zip
  </code></pre>
  
  <p>Name (new line)</p>
  
  <pre><code>address,state,zip
  </code></pre>
  
  <p>Query:</p>
  
  <pre><code>select 
      name + char(13) + concat(address,',', state,',', zip)   
  from 
      tbl1  
  join 
      tbl2 on.... 
  </code></pre>
  
  <p>I am not able to get the desired output. I get <code>concat</code> is not a recognized built in function name.</p>