Hi
I have post the Code.
Male To FeMale Simple Logic Query. Update Table2 set Gender='Male1' where Gender='FeMale'
Select * from dbo.Table2
Update Table2 set Gender='FeMale' where Gender='Male'
Select * from dbo.Table2
Update Table2 set Gender='Male' where Gender='Male1'
Select * from dbo.Table2