I've found SQL tends to be explicit.
Which removes unpleasant surprises like the one you were expecting. Hence the IS NULL clause.
Wade.
Is it enough to love Is it enough to breathe Somebody rip my heart out And leave me here to bleed
| | Is it enough to die Somebody save my life I'd rather be Anything but Ordinary Please
| -- "Anything but Ordinary" by Avril Lavigne. |