UPDATE TableSET col1 =CASE department WHEN 'AAA' THEN 'aaa' WHEN 'BBB' THEN 'bbb' WHEN 'CCC' THEN 'cc' ELSE col1 ENDWHERE department IN ('AAA', 'BBB', 'CCC')