title: Using ISNULL() on case expression result
body: <p>I have a large case expression</p>
  
  <p>e.g.</p>
  
  <pre><code>CASE WHEN ... THEN ... ELSE
  CASE WHEN ... THEN ... ELSE '' END ELSE '' END +
  CASE WHEN ... THEN ... ELSE
  CASE WHEN ... THEN ... ELSE '' END ELSE '' END as [Test]
  </code></pre>
  
  <p>Now the [Test] column returns some NULLS. How can i wrap this CASE expression with (ISNULL, '') so that if it is NULL it is just blank?</p>
  
  <p>What is the cleanest way to accomplish this with a very large case statement?</p>