I assume that you meant that the table should have many records with null value in this column, but the rest of the values should be unique. If I'm correct then you can try and use filtered unique index on that table (the filter would be of course on the null value).

Adi