>Thank you.
>
>>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 agree - either trigger or calculated column. Or even an updatable view - I had this idea discussed several months ago in MSDN forum - it will be a bit tricky to find the thread, though.
If it's not broken, fix it until it is.
My Blog