unique constraint with conditioning?

Hi All:

Is there a way to create a unique constraint with 4 fields combined, such as colA, colB, colC, and colD.

but colD is for all the values but value = 3.

If this does not work out, trigger probably is the last way I would like to approach. and it is slower than constraint with many inserts.

thanks
David

Unique constraint will not work that way.

rmiao:

thanks the info. Have to go to trigger..

-D