We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

CREATE  TABLE #Temp (b BIT NOT NULL);

INSERT  #Temp VALUES (1);
--INSERT  #Temp VALUES ('True'); -- 2005 onward
INSERT  #Temp VALUES (456);

-- Success
SELECT  *
FROM    #Temp
WHERE   b = 1;

-- No rows
-- 456 is interpreted as an integer
-- Integer has a higher precedence than BIT
-- So the BIT column value is converted to an integer
-- to make the comparison
SELECT  *
FROM    #Temp
WHERE   b = 456;

-- Success
SELECT  *
FROM    #Temp
WHERE   b = CONVERT(BIT, 456);

DROP    TABLE #Temp;