The question asked to OP by interviewer was probably like
"flip the values from A to B and B to A "
was actually answered by "Koen Verbeeck " in his first post here.
AS this is (i often experience this) very frequently asked question to people who are having exp from 3 to 5 yrs.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)