<pre lang="SQL">UPDATE dbo.GenderTable SET gender = CASE WHEN 'F' THEN 'M' WHEN 'M' THEN 'F' END</pre>
'An expression of non-boolean type specified in a context where a condition is expected, near 'THEN'.'
UPDATE dbo.GenderTable SET Gender = CASE Gender WHEN 'F' THEN 'M' WHEN 'M' THEN 'F' END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)