nitinkachhwaha (10/10/2013)
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
Well done. Great reply.:hehe: