Make a varcharunique without making it a Primary Key

[Adam]

Anybody know a way to make a varchar field not allow duplicates besides
making it a primary key?

 

[Karen Vaudreuil]

You can create a unique index. See the Books Online for help on how to do
that.