title: Concat two column in a select statement sql server 2005
body: <p>How to Concat two column in a select statement sql server 2005?</p>
  
  <p>Here is my statement <code>Select FirstName,secondName from Table</code>...</p>
  
  <p>Now i did try concating <code>secondName</code> with <code>FirstName</code> by using </p>
  
  <pre><code>Select FirstName + ' ' + secondName from Table
  </code></pre>
  
  <p>But some values are <code>NULL</code> in secondName column for some records.. My select statement 
  returns <code>NULL</code> instead of <code>FirstName</code>.. I want to have <code>FirstName</code> if secondName is <code>NULL</code> ..</p>