0
Given a table with a single column containing only 2 values, say 'A' and 'B', is there a way to swap them in a single statement
Ex:
A
B
A
B
to
B
A
B
A
It is a trivial process if we use a bit or a placeholder value, (Change all A to C, all B to A, all C to B), but is there a generalized method to do this?