>I am trying to create a primary key for my table out of the following index called "keydex" :
>
> custid+upsino+DTOS(puldat)+STR(sampleno,2)
>

First of all make sure SET DELETE is OFF.

THen use this query to find dupes:

SELECT COUNT(*), custid+upsino+DTOS(puldat)+STR(sampleno,2) FROM MyTable GROUP BY 1 HAVING COUNT(*) > 1