title: Microsoft Access - Case Query
body: <p>I've just try using MS Access 2007
  now I want to update a column based on other column value, in MY SQL it was successfull running this query</p>
  
  <pre><code>UPDATE HAI
  SET REGION=(
  CASE
    WHEN (NUMREG LIKE '%1') THEN 'BDG'
    WHEN (NUMREG LIKE '%2') THEN 'JKT'
    WHEN (NUMREG LIKE '%3') THEN 'KNG'
  END);
  </code></pre>
  
  <p>This query won't run in MS Access, there is error <code>Sytax error (missing operator) in query expression</code>. How can I solve this? </p>