UPDATE employee SET staff_no = CASE depno WHEN 1 THEN 'ab123' WHEN 2 THEN 'ab321' --... ELSE staff_no END WHERE depno IN ( 1, 2 ) -- list all cases here. use a subquery if you don't want to / cannot enumerate