This "should" be simple: I have a bit column and want to select it's negation. However this fails:
Select Not <column name> from <table>
So far I'm using the absurdly long:
select convert(bit, (case when <column name> = 'true' then 'false' else 'true' end)) from <table>
Anything friendlier than this?
View Complete Post