Convert integer 0101 into 1010 and 11 to 00 in SQL server

Transact-SQL
1

Convert 0 to 1 and 1 to 0 in a single column
For example : 1100 to 0011
10101 to 01010
And so on

2

Help me on this!!!

3

Is this homework orreal world problem? What are you trying to solve

4

Real time problem, need to get this value for a variable so that I can parse the result....

5

Demanding help as if by shouting is not appropriate. Any help given here is by volunteers, and you must show that you are making an effort. You didn't even state the type of the data you are trying to change or the purpose.

6 
SELECT data, REPLACE(REPLACE(REPLACE(data, '0', '~'), '1', '0'), '~', '1')
FROM ( VALUES('1100'),('10101'),('0101') ) testdata ( data )