title: SQL Server Subtract certain percent
body: <p>I'm trying to subtract a certain percent of my price, into a AS columm.</p>
  
  <pre><code>SELECT TOP 2 *, price - (price * (discount/100)) AS discountedPrice 
  FROM products 
  WHERE discount != 0
  </code></pre>
  
  <p>But this seems not to work. What have I done wrong?</p>
  
  <p>I want it like this, let's say price is 500 and discount is 20. Then it'll have to subtract those 20 as percent of the 500.</p>
  
  <p>So 500 - 20%, just in SQL Server format.</p>