title: How subtract fixed number from SQL Server column
body: <p>If I have a SQL Server table like </p>
  
  <pre><code>Code      Name         Value
  --------------------------------------------
  1         A            10
  2         B            20
  3         C            40
  4         d            70
  </code></pre>
  
  <p>how subtract a fixed number like <code>100</code> from the SQL Server column, to get a result like this </p>
  
  <pre><code>Code      Name         Value      net
  --------------------------------------------
  1         A            10         90  (100 - 10) 
  2         B            20         70  (90 - 20)
  3         C            40         30  (70 - 40)
  4         d            70        -40  (30 - 70)     
  </code></pre>
  
  <p>Please can anyone please help me?</p>