How do I check for a null value in a boolean field in my DB?

I keep getting a type mismatch error when trying to check the field for a value and I know it has a null value in the DB...

???


-------------------------
Beware of programmers with screwdrivers...

__________________
-------------------------
Beware of programmers with screwdrivers...

You would get the mismatch error because a Boolean field is always a bit-field, meaning the bit is either on or off, '1'B or '0'B, in basic it is either '-1'B or '0'B, but never null. However you can set the bit, as a default value.

Hope this helps.

peace95

Thanks. The table I am working with has about 2000 records and whoever set it up in the beginning allowed null values in the boolean fields. Now most of the bools are filled with null, as well as a few date fields and others too.

I guess I can use a simple function to check for true/false and return false if there's an (type mismatch) error, but I guess I was hoping there was something like IsNull() for bools in ASP...

-------------------------
Beware of programmers with screwdrivers...