shini2007 (9/16/2010)
I think":" Converting to bit promotes any nonzero value to 1" not greater than zero only BecauseDECLARE @bit BIT
SET @bit = -14
IF @bit = 1PRINT 'yes'ELSE PRINT 'no'
is also give yes.
Non-zero does not mean greater than zero, it means not zero.
-14 is not zero, so it is converted to 1, as I said.
Does that make sense?
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi