As I said, you can use a trigger to perform as fancy checks as you want. Or you can create a calculated column and put Unique constraint on it.

>I am sorry that I didn't explain myself correctly. There are two columns, MyField1 and MyField2. MyField1 is not unique but only unique with value of '1' in column MyField2.
>