title: SQL Server Convert in Case Statement
body: <p>I have a column called compositeRate, it is a decimal(10,2) datatype. I am writing a Select statement that should return empty string if compositeRate is 0.00
  however I am getting this error:
  Msg 8114, Level 16, State 5, Line 1
  Error converting data type varchar to numeric.</p>
  
  <p>This is my case statement</p>
  
  <pre><code>select CASE WHEN compositeRate = 0.00 THEN '' else compositeRate from table
  </code></pre>
  
  <p>Could you please let me know where should I write convert in my case statement?</p>