title: Arithmetic overflow error converting varchar to data type numeric?
body: <pre><code>SELECT CASE Price WHEN '' THEN 0.0 ELSE Price END FROM Table
  </code></pre>
  
  <p>If price empty, it returns 0.0 but if column has value it gives me the error below</p>
  
  <p><strong>Arithmetic overflow error converting varchar to data type numeric.</strong></p>
  
  <p>How to change my code to handle this case?</p>