i have created a table called employ, that consists a column called gender, in which i have stored with male and female.
i want to convert male to female and female to male.
plz help me out of ths query
Example:
table name : employ
column name : gender
gender
------
male
female
male
female
female
i want to convert male to female and female to male