UPDATE dbo.TestStudents SET LASTNAME = CASE LASTNAME WHEN 'AAA' THEN 'BBB' WHEN 'CCC' THEN 'DDD' WHEN 'EEE' THEN 'FFF' END WHERE LASTNAME IN ('AAA', 'CCC', 'EEE');