Ajit Khodke
asked on
UPDATE SQL statement
Hello friends,
I want to update all F (female) and M (Male) values (change all F values to M and vice versa) as per below table.
Id >> Name >> Sex >> Salary
1 >> A >> M >> 6000
2 >> B >> F >> 3500
3 >> C >> M >> 8500
4 >> D >> F >> 600
How should I write the query to update the values?
I want to update all F (female) and M (Male) values (change all F values to M and vice versa) as per below table.
Id >> Name >> Sex >> Salary
1 >> A >> M >> 6000
2 >> B >> F >> 3500
3 >> C >> M >> 8500
4 >> D >> F >> 600
How should I write the query to update the values?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Fixed..
Thanks Jim and bbao for great solution.
Thanks Jim and bbao for great solution.
Ajit Khodke - Let us know if these solutions met your needs.