Youre right. I think I wanted "Not In".

Jason

Ivan Prenosil wrote:

>>Alter Table Company
>>Add Constraint CK_NAME Check (Not Exists (Select Distinct Upper(Name)
>>from Company));
>
>
> This constraint will allow inserting one row (or perhaps few more since it is not multiuser safe),
> regardless company name :-)
>
> Ivan