peter_jacobi.rm wrote:

> For my designs I try to use a specific value for null-ness. If domain
> analysis confirms, that '' has no distinct meaning from NULL, I
> declare the column NOT NULL DEFAULT ''.

Yes, just been caught by that one :)
Needed to add UNIQUE to a column that had been previously
DEFAULT ''.
THEN you know why NULL exists ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services