Loading

SQL Server Query to Interchage row value

Bineesh Viswanath

13y1.2k

Sir, I need your help in the following topic.

I have a table named tbl_Person. It has columns: id(numeric(18,0), firstName(varchar(20), Gender(int).

please find the attached file with this for screenshot.

in that, I gave value 1 to Male and 2 to Female. Then all row with gender male show 1 and female with 2.

Now I want to change the Female corresponding number from 2 to 1 and male from 1 to 2.

Please give me the query to interchange the value of rows.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi13y ago
Accepted answer
hi,
Try following query

UPDATE tbl_Person
set Gender = CASE WHEN Gender = 1 THEN 2 ELSE 1 END

hope this will help you....
venkata kumar13y ago
hi
try what ever jignesh told