Good QOD.This Question gives good information about bit datatypes.
when we use space or all zero it bit will convert it into zero.If we give numeric(numbers) it will convert it into one.
declare @bit bit
set @bit='233677788778'
select @bit
This gives 1 as output.
declare @bit bit
set @bit='00000'
select @bit
This gives 1 as output.
declare @bit bit
set @bit=' '
select @bit
This gives 0 as output.
Malleswarareddy
I.T.Analyst
MCITP(70-451)