Showing posts with label Update Statement for converting male to female and female to male. Show all posts
Showing posts with label Update Statement for converting male to female and female to male. Show all posts
Wednesday, March 24, 2010
Update Statement for converting male to female and female to male
Update tablename set gender=(case, when gender='Male' then 'Female' else 'Male' end)
Subscribe to:
Posts (Atom)