title: SQL Server: Best way to concatenate multiple columns?
body: <p>I am trying to concatenate multiple columns in a query in SQL Server 11.00.3393.</p>
  
  <p>I tried the new function <code>CONCAT()</code> but it's not working when I use more than two columns.</p>
  
  <p>So I wonder if that's the best way to solve the problem:</p>
  
  <pre><code>SELECT CONCAT(CONCAT(CONCAT(COLUMN1,COLUMN2),COLUMN3),COLUMN4) FROM myTable
  </code></pre>
  
  <p>I can't use <code>COLUMN1 + COLUMN2</code> because of <code>NULL</code> values.</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>If I try <code>SELECT CONCAT('1','2','3') AS RESULT</code> I get an error </p>
  
  <blockquote>
    <p>The CONCAT function requires 2 argument(s)</p>
  </blockquote>