title: CASE WHEN [COLUMN] IS NULL THEN '0' ...Not Working
body: <p>The following is a simple query that I am running to rectify <code>NULL</code>s by making them <code>'0'</code>:</p>
  
  <pre><code>SELECT 
      CASE WHEN R.P IS NULL THEN '0' ELSE R.P END AS 'RectifyNull'
  FROM 
      RBase r
  </code></pre>
  
  <p>This is still returning me <code>NULL</code> values when I want a string value of <code>0</code> in the results instead of the <code>NULL</code></p>
  
  <p>What am I doing wrong?</p>