title: Replace NULL with 0
body: <p>I have the following <code>CASE</code> expression that separates data into different categories and attach corresponding hours.</p>
  <pre><code>case
  when Wstat_Name_Ch like '%Overtime signup%' then payhours
  end as All_OT_Signup,
  case
  when  Wstat_Abrv_Ch in ('CO', 'COU', 'Otnoshow') then payhours
  end as OT_Removed,
  case
  when  Wstat_Abrv_Ch in ('Ov', 'OTField', 'MinStafotp', 'OvUpsOT') then payhours
  end as OT_Hours_Worked
  </code></pre>
  <p>The statement returns data like this:</p>
  <pre><code>All_OT_Signup    OT_Removed   OT_Hours_Worked
  500.00            NULL         NULL
  350.00            150.00       100.00
  200.00            NULL         NULL
  </code></pre>
  <p>what I need to do is replace any NULL with 0. I tried <code>ISNULL(payhours, 0)</code> in place of payhours, but it did not work.</p>