Syntax for unique alter table statement

I've tried the following which doesn't to the trick ...

alter table branch add constraint branch_mj_uk check (branch is unique)

Note that I want to allow nulls but if an entry is not null it must be unique.

Thanks Received on Fri Nov 05 2004 - 13:27:26 CST