Q&A for experienced flyers, pilots, and builders of drones and model aircraft
declare @t table(row int, isalive bit) insert @t values (1,1) insert @t values (2,0) insert @t values (3,null) declare @isalive bit SELECT * FROM @t where ( (1-coalesce(isalive, 0)) ^ @isalive ) = 0