title: ISNULL with PIVOT in SQL
body: <p>With pivot, I need to replace all null values and 0 values with a dash. I started with getting rid of null values:</p>
  <pre><code>  SELECT FunctionCode, ISNULL(Col1, '-') AS Col1, ISNULL(Col2, '-') AS Col2
    FROM
    (
      SELECT Company, FunctionCode, [Count]
      FROM MyTable
    ) AS D
    PIVOT
    (
      SUM([Count])
      FOR Company IN (Col1, Col2)
    ) PIV;
  </code></pre>
  <p>For some reason, NULL is replaced with 0 instead of '-'. What can I try next?</p>