Hi Jeremy,
I am sorry, but you cannot do this with RDBMS. Every value has to be unique, and NULL is a value of its own, so two NULLS will be a duplicate key failure. You can either make the column a Unique contraint, or a NULL, but they are mutually exclusive.
Tim