title: SQL server - update VARCHAR value to DECIMAL
body: <p>Increase the rate by 10 percent of nurse resource in the resource table.
  <a href="https://i.stack.imgur.com/GMlV1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GMlV1.png" alt="enter image description here"></a></p>
  
  <p>I try this code but fails</p>
  
  <pre><code>UPDATE Resourcetbl 
  SET  Rate = convert(varchar(255), convert(decimal(10,2), Rate * 1.1))
  WHERE ResName = 'nurse';
  </code></pre>
  
  <p>I get error message Arithmetic overflow error converting varchar to data type numeric.</p>
  
  <hr>
  
  <p>Rate is VARCHAR(20) </p>