Update a Column

[neelam26]

Hi,

I have a table named Employee having column as Gender storing values 'M' and 'F' accordingly.Hel p me to write a update query where the 'M values n the field are updated to 'F' and vice versa

Thanks and regards
Neelam

[frozenmist]

Hi Neelam,

You can use a case statement for this.
The query can be like:

update Employee set Gender=
   case when Gender='M' then 'F' else  'M'
   end

Hope this answers your problem.
Cheers

[neelam26]

Hi,

Hey thanx a lot...it worked...ws bit cnofused...bt neways

Hi Neelam,

You can use a case statement for this.
The query can be like:

update Employee set Gender=
   case when Gender='M' then 'F' else  'M'
   end

Hope this answers your problem.
Cheers

[frozenmist]

Hi Neelam,
What was the confusion about?
The case statement returns M if the current value is F and Vice versa.
Then just update using this returned value.

Cheers