• 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)