constraint question on uniqueness

Is there any way to create a constraint (probably a CHECK constraint) that would inforce uniqueness for
one type of value for that column.

e.g.

row1, col1 = "active"
row2, col1 = "pending"
row3, col1 = "pending"

Thus the value "active" can only be specified for one row at a time. "pending" will be specified for all other rows.

thanx in advance. Received on Mon Dec 03 2001 - 09:52:49 CST