Insert trigger to enforce uniqueness

Hi,

Our third party application doesn't allow to create Unique indexes on a column.
I want to write an insert trigger which allow nulls but no duplicate values on a column (peopleID column). Waht is the best way to write BEFORE INSERT TRIGGER for thsi kind of requirement? Please give sample Received on Sun Mar 03 2002 - 19:43:59 CST