Re: [GENERAL] How to create unique constraint on NULL columns

[Michael Schmidt]

I was faced with a similar issue.  One suggestion I got from the Internet was to create a shadow column that contains the values used in the Index, with a dummy entry (in my case, the string <NULL>) for those records in which the primary column is NULL.  It works well for my app.