title: SQL Server SELECT Money as blank space instead of 0.00
body: <p>I am having trouble getting my values to come back as blank instead of 0.00 in a table variable.</p>
  
  <p>Table Setup/Declaration.</p>
  
  <pre><code>        DECLARE @PolicyCoverages TABLE (
          CoverageType varchar(100),
          ScheduleLimit money,
          BlanketLimit money,
          Deductible money,
          Premium money
      )
  
      INSERT INTO @PolicyCoverages (CoverageType, ScheduleLimit, BlanketLimit, Deductible, Premium)    
      SELECT  'Words for a description',
              '10000.00', 
              '0.00', 
              '2500.00', 
              '142.50'
  </code></pre>
  
  <p>Once all the data is in place (there are many selects that pull in data) I want to pull specific information as shown below.</p>
  
  <pre><code>SELECT CoverageType,
         CASE WHEN ScheduleLimit &lt; 0 THEN '' ELSE ScheduleLimit END AS ScheduleLimit,
         CASE BlanketLimit WHEN '0.00' THEN '' ELSE BlanketLimit END AS BlanketLimit,
         Deductible, 
         Premium 
      FROM @PolicyCoverages
      WHERE (ScheduleLimit &gt; '0.00') OR (BlanketLimit &gt; '0.00')
  </code></pre>
  
  <p>I do NOT want to display 0.00 I instead want a blank space ''.  I've tried converts, I tried cast, and the two shown WHEN attempts.</p>
  
  <pre><code>WHEN CAST(ScheduleLimit as varchar(10)) &lt; 0 THEN ''
  WHEN Schedulelilmit &lt; 0 THEN CONVERT(varchar(10), '')
  </code></pre>
  
  <p>No matter which way I attempt this it comes over as 0.00</p>