>>>>Hi,
>>>>
>>>>When setting up table unique constraint I wanted to have a column value as part of the expression but don't seem to see how to do it in SSMS. For example, say I want the constraint to be on column MyColumn1 plus MyColumn2='1'. Can this be done?
>>>>
>>>>TIA.
>>>
>>>There doesn't seem to be a way to do this in the design view. You need to do this in code - specify unique constraint on both columns.
>>
>>I will try the approach of Check constraint as Sergey suggested. Thank you.
>
>If you want some calculations like you described, then you need to use a Check constraint. Check constraint you can design visually.
Please see my second message to Sergey on what I am trying to do.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham