Creat Unique constraint on MyField and "MyField + '1'" will be unique as well. If some check cannot be done with Check constraint, use a trigger.

>After consulting my SQL Server book I am not sure Check constraint will do the job. I don't see how I can specify to check for unique expression. Here is what I was trying to do: I want to make sure that that value "MyField + '1'" is unique for all rows in the table. Could this be done with Check constraint?
>
>>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.
>>