update a set status=(case when status='YES' then 'NO'
when status='NO' then 'YES'
end)
Showing posts with label swap yes to no and no to yes. Show all posts
Showing posts with label swap yes to no and no to yes. Show all posts
Saturday, August 18, 2012
Swap YES,NO values in a table column with single update statement.....
update a set status=(case when status='YES' then 'NO'
when status='NO' then 'YES'
end)
Subscribe to:
Posts (Atom)