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
UPDATE HAI
SET REGION=(
CASE
WHEN (NUMREG LIKE '%1') THEN 'BDG'
WHEN (NUMREG LIKE '%2') THEN 'JKT'
WHEN (NUMREG LIKE '%3') THEN 'KNG'
END);
This query won't run in MS Access, there is error Sytax error (missing operator) in query expression. How can I solve this?