Bob,

I'll check that out. I didn't realize you could impose a uniqueness constraint if nulls were allowed. Sounds like just what I need. Thanks.

>
>How about making the column accept nulls and put a unique constraint on it. This will get you what you want without writing any code. (Except the code to handle the error.
>