<p>I would like a constraint on a SQL Server 2000 table column that is sort of a combination of a foreign key and a check constraint.  The value of my column must exist in the other table, but I am only concerned with values in the other table where one of its columns equal a specified value.  The simplified tables are:</p>

<pre>
import_table:
part_number  varchar(30)
quantity     int

inventory_master:
part_number  varchar(30)
type         char(1)
</pre>

<p>So I want to ensure the <code>part_number</code> exists in <code>inventory_master</code>, but only if the type is 'C'.  Is this possible?  Thanks.</p>

```
```
sp_help tablename
```
```
In the output look for something like this:
```
```
Identity     Seed     Increment     Not For Replication    
 -----------  -------  ------------  ---------------------- 
 userid       15500    1             0
```
```