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