title: How to negate a bit column value in SQL
body: <p>How do I update a table column in order to revert its value(set true if value is false and false for true! null remains null). </p>
  
  <p>Please exclude solutions where one uses <code>case when</code> or <code>IIF()</code> I want something like following</p>
  
  <pre><code>UPDATE mytable SET IsEditable = !IsEditable
  </code></pre>