The syntax for this query always trips me up. I am always under the impression I can select rows from the ‘bit’ column of my tables, where [myBitColumn] DOES NOT CONTAIN A VALUE OF 1 (in other words a value of FALSE or NULL), by using the following WHERE clause in my SQL query:
[myBitColumn] != 1
If you have ever tried you know this does not work. Instead, your WHERE clause needs to check if the value is either FALSE or NULL, like so:
[myBitColumn] = 'False' OR [myBitColumn] IS NULL