Anand writes "Hi all please help me in my query one recruiter ask me how to do this. here it is what they did ask me:-------there is one table in that table two columns name and gender and the things is that suppose the table is like that

Name GenderKen Mkate FLucy FBrian M

so please what we have to do write only one single query which we will select all the male from the databse and update them to female and all female to Mail but this should be only in one single query.Not a two query at all okplease help i did use select case but no luck!!!:( please reply to me onephpguy@yahoo.comThanks to whole SQL team."