title: how to insert '-' in money column when value is 0.00
body: <p>How to insert <code>'-'</code> when value is <code>0.00</code> in result set, the summary in crystal report doesn't work?</p>
  
  <pre><code>Create Table #Results
  (
      TerminalNumber       INT,
      ContractNumber       VARCHAR(50),
      CustomerName  VARCHAR(80),
      TotalDeficiency NUMERIC(13,2),
      TotalIncremental NUMERIC(13,2),
      MonthPeriod VARCHAR(20)
  )
  
  
  
  
  SELECT TerminalNumber
        ,ContractNumber
        ,CustomerName
        ,CASE WHEN TotalDeficiency = 0.00 THEN '-' ELSE CAST(TotalDeficiency AS NUMERIC(13,2)) END AS TotalDeficiency 
        ,CASE WHEN TotalIncremental = 0.00 THEN '-' ELSE CAST(TotalIncremental AS NUMERIC(13,2)) END AS TotalIncremental 
        ,MonthPeriod
        ,CONVERT(VARCHAR(10), @billing_date, 101) 'BillingDate' 
        FROM #Results order by CustomerName
  </code></pre>