I'm confused. Do you need Unique constraint or Check constraint? A Table Check constraint can reference more then one column of the table to which it belongs. A Unique constraint does not support expressions, only column list.
>
>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.
--sb--