Norman,

How are you "asking" for unique? If it is with a UNIQUE index, then that is why you get dups, unique indexes do not force uniqueness on the expression, they never have. You can use a primary or condidate index type instead and they will force uniqueness on the expression.