Select where bit is not 0
See following results:


'true' != 'true' → false
'false' != 'true' → true
NULL != 'true' → null (and equivalent to false in WHERE because it is not true)


What you can do is use COALESCE to change null into 'false'

SELECT * FROM Table WHERE COALESCE(Bool, 'false') != 'true';