copy value from one variable to another variable

[Dhana18]

I have a daset like this

IncidentID	MENSEX	MaleSexPartners
1	1	0
2	10	0
3	1	1
4	1	0
5	2	0
7	5	5
10	5	0
12	5	0
13	5	0

I would like to copy variable from MENSEX variable to malesexpartners variable ONLY if malesexpartners's value is "0". I want my data to look like this

IncidentID	MENSEX	MaleSexPartners
1	1	1
2	10	10
3	1	1
4	1	1
5	2	2
7	5	5
10	5	5
12	5	5
13	5	5

Please help me. Thank you

[Reeza]

Have you tried an IF/THEN statement?
Or a CASE statement in SQL?

If so, please post the code you've tried that's not working.

[Reeza]

Or IFN/IFC depending on if the variable is character or numeric.

[Dhana18]

Yes, I used if then statement and it worked. Thank you.