title: sql server query to add value to existing value
body: <p>I have a table with few columns, one of these columns called _bandwidth and the value inside it is decimal.</p>
  
  <p>So i wanna type a sql query that adds values to existing value.</p>
  
  <p>Say the value of _bandwidth of user id 1 is 150.000 and i wanna add 200 to this value so sum would be 350.000</p>
  
  <p>This is the query i typed but it didin't work.</p>
  
  <pre><code>update users set _bandwidth = (select _bandiwdth from users where _ID = 1) + 150 where _ID = 1
  </code></pre>
  
  <p>Also did something like:</p>
  
  <pre><code>update users set _bandwidth += 200 where _ID = 1
  </code></pre>
  
  <p>Of course they are wrong, but i hope you understand what i wanna achieve.</p>
  
  <p>Thanks a lot in advance.</p>
  
  <p><strong>EDIT</strong>
  Found the solution and the answer would be:</p>
  
  <pre><code>update users set _bandwidth = _bandwidth + 200 where _ID = 1
  </code></pre>