alter table tablename ADD PARTYC varchar(250);
update tablename set PARTYC = PARTYA where TYPE=5;
update tablename set PARTYA = PARTYB where TYPE=5;
update tablename set PARTYB = PARTYC where TYPE=5;
alter table tablename DROP column PARTYC;
update tablename set PARTYC = PARTYA where TYPE=5;
update tablename set PARTYA = PARTYB where TYPE=5;
update tablename set PARTYB = PARTYC where TYPE=5;
alter table tablename DROP column PARTYC;