Subject Unique key that accepts null
Author junior

Is it possible to create a unique key that accepts null value, just like MS Access 2000? I have tried to create a unique constraint that defaults null value, but failed. My purpose is to make sure that the value is not duplicated and at the same time allow the users to leave it blank.

Thanks in advance.

Best wishes,

[Non-text portions of this message have been removed]