title: CONCAT'ing NULL fields
body: <p>I have a table with three fields, FirstName, LastName and Email.</p>
  
  <p>Here's some dummy data:</p>
  
  <pre><code>FirstName | LastName | Email
  Adam        West       adam@west.com
  Joe         Schmoe     NULL
  </code></pre>
  
  <p>Now, if I do:</p>
  
  <pre><code>SELECT CONCAT(FirstName, LastName, Email) as Vitals FROM MEMBERS
  </code></pre>
  
  <p>Vitals for Joe is null, as there is a single null field. How do you overcome this behaviour? Also, is this the default behaviour in MS SQL Server?</p>