>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.
If it's not broken, fix it until it is.
My Blog