Hi,

Please find the query to update the cty to 'A' where cty is 'B' and from cty 'B' to 'A'.

BEGIN TRAN

SELECT *FROM CITY

UPDATE CITY

SET CTY = CASE WHEN CTY = 'A' THEN 'B'

WHEN CTY ='B' THEN 'A'

END

SELECT *FROM CITY

ROLLBACK