title: COALESCE Function in TSQL
body: <p>Can someone explain how the COALESCE function in TSQL works?  The syntax is as follows</p>
  
  <blockquote>
    <p>COALESCE(x, y)</p>
  </blockquote>
  
  <p>The MSDN document on this function is pretty vague</p>