title: Show 0 Not Null With Pivot
body: <p>Why is my <code>Coalesce()</code> statement in my initial <code>Select</code> statement not replacing the <code>Null</code> with a 0?</p>
  
  <pre><code>Select * From
  (
      Select a.orderstatus As [Stat], Coalesce(Count(b.id), '0') As [Count], b.region
      From orderstatus a
      Left Join saleinfo b
      on b.orderstatus = a.orderstatus
      Group By a.orderstatus, b.region
  ) one
      pivot ( Max([Count]) For region In ([East], [West], [North], [South]) ) pv
  </code></pre>