How to negate a bit column value in SQL August 12, 2023 by Tarik You can use bitwise NOT operator: update mytable set IsEditable = ~IsEditable