title: SQL - CASE NULL
body: <p>I have the following sql</p>
  
  <pre><code>case gg.finalgrade
   when NULL
     then 'Nothing to Show'
   else gg.finalgrade
  end as 'Grade'
  </code></pre>
  
  <p>Many of my gg.finalgrade values is shown in the database as NULL, but the above statement simply ignores those values and does not print anything. I want it to show 'Nothing to Show' when the value is NULL.</p>
  
  <p>I have looked at some examples on SO but can't seem to get them to work.</p>
  
  <p>Thanks!</p>