title: LPAD and RPAD on a CASE statement
body: <p>I'm trying to pad to the left and right of a case statement with 3 asterisks.  It runs but the values don't show up for the Null values.  Any ideas? </p>
  
  <pre><code>SELECT p.patientfirstname || ' ' || p.patientlastname AS "Patient"  
  ,CASE WHEN i.insuranceid IS NULL THEN RPAD(LPAD('No insurance', 3, '*'), 3, '*')
   ELSE i.insurancename 
   END "Insurance Name"
  FROM patient p 
  FULL OUTER JOIN insurance i ON (p.insuranceid = i.insuranceid);
  </code></pre>