>Hi:
>
>In a Bit datatype, what's the purpose of having a 'NULL' value? In what case/scenario do we encounter this kind of value? I'm just wondering so I'll be aware when using a Bit datatype.
>
>Thanks,
>Jan

If you don't set default value for the BIT type and if you insert a record without providing an explicit value, the bit value will become NULL.

You can consider this as "unknown" state or no answer given.