title: How do I use CASE in SQL for my example?
body: <p>I have 3 columns of data: Age, Gender, Points.
  Age is age, gender is either M or F, and Points range from 1-100.</p>
  
  <p>How do I make a new column so that if gender is M you add 5 points to whatever is in the Points column, and if gender is F you subtract 3 points from whatever is in the Points column?</p>
  
  <p>I think I'm going to need CASE.  I've added a new column called PointsRevised by using ALTER TABLE, then add.</p>
  
  <p>Now, I want to populate this new PointsRevised column with new values depending if gender is M or F.</p>
  
  <pre><code>UPDATE [Example].[dbo].[example]
  SET POINTSREVISED
  CASE 
  WHEN Gender = 'M' Then PointsRevised = Points + 5  
  WHEN Gender = 'F' Then PointsRevised = Points - 3
  END
  </code></pre>
  
  <p>I'm clearly doing something wrong.</p>