with ansi nulls on: NULL is like a black hole that converts anything it comes into contact with to NULL as well. Kind of like a vampire, NULL bites other values on the neck then what do you know, there vampries (NULL) to.

This is of course if you do not use ISNULL/IS NULL which is like garlic for NULL.

Carlton..