title: Using case statement in update query
body: <p>Is it possible to use case statement within an update query? I need to do something like this: If person name starts with 'S' then append '1', else append '2'.</p>
  
  <p>I tried this in sql server and it didn't work</p>
  
  <pre>
  UPDATE PERSON
  CASE
  WHEN NAME LIKE 'S%' THEN SET NAME = NAME + '1'
  ELSE SET NAME = NAME + '2'
  END
  </pre>