title: SQL， Error converting data type varchar to numeric
body: <pre><code>SELECT LIFNR,
   SUM(CASE WHEN  UPPER([WAERS])='USD' THEN ROUND(CONVERT(numeric(10,2),DMBTR)* (-1),2)
                 WHEN UPPER(WAERS)='USD' THEN ROUND(CONVERT(numeric(10,2),DMBTR),2) 
                 ELSE ROUND(CONVERT(numeric(10,2),DMBTR),2)
                 END)
  AS 'AMOUNT'
  FROM tbl_BSAK
  GROUP BY LIFNR;
  </code></pre>
  
  <p>Hi, everyone.</p>
  
  <p>I just wrote a piece of code and I keep getting the error message saying 'Error converting data type varchar to numeric.' I'm sure it's simple fix, but I have spent way too much time troubleshooting...</p>
  
  <p>Please help me!!!!Thanks a ton!!!</p>