title: Updating multiple values within the one column
body: <p>I have the following SQL which I have written to update a tables values:</p>
  
  <pre><code>Update Table
  SET S_Type = 'Versus'
  Where S_Type = 'REGULAR'
  SET S_Type = 'Free'
  Where S_Type = 'CASH';
  </code></pre>
  
  <p>My SQL is rather rusty, and my colleague told me something was up with it but didn't tell me what!</p>
  
  <p>The only thing that comes to mind is I have not referred to the Table.Column in the set and Where code.</p>
  
  <p>Is there any issue updating a column as such? What is the best practice when updating a column for multiple values?</p>
  
  <p>Cheers </p>