Matt wrote " think the issue being taken is that you start with the presumption that NULL is "bad".

Actually I dont have a view in that sense (because its...

Sorry - I was imprecise in what I wrote. I meant to say that DOUBLE can be an example of a domain which contains more than just primitives.

Then I...

ACTUALLY I was hoping to get a poll of what people are actually doing to mitigate NULLs - how do I do that?

I am happy to discuss NULL as well...

Reductio ad absurdum ("20,000 possible combinations") does not hold here because there are plenty of cases where the real -world data should be modeled but either isn't or cannot...

The values in a table column have a type (or domain if you prefer in the non-SQL meaning of the word) which defines, loosely, the possible values the column may...

Hi Jeff

You used two different meanings for NUL: "not been processed [for Commissions] yet" and "not known"

Or presumably therefore when you say "You must understand what it means when something...

"numeric expressions ....NULL can be thought of as infinity"

Infinity is mathematically a number.

What is the equivalent "can be thought of" for DATE, VARCHAR values?

Jeff - In which ways can you deal with the problems caused by NULL then - for example the fact that TRUE AND NULL = NULL or 6 * NULL...