Lots of posts and comments but none of them, including the answer code, shows a UNIQUE CONSTRAINT on a TABLE column that allows more than one NULL value.

A UNIQUE INDEX is not a UNIQUE CONSTAINT and they are used for two differant things.