>THanks Evan:
I got it to work using this after:
select sin, add_date, add_time, count(*) as cnt from employ into cursor temp group by 1,2,3 having count(*) > 1
>Hi:
>>
>>I want to list duplicate records that are violating my primary key of sin+dtos(add_date) + add_time form my employ table.
>
>Off the top of my head
>
>SELECT cnt(sin) as dupcnt, sin+dtos(add_date) + add_time as pkey ;
> FROM sheenatable ;
> ORDER BY 1 DESC ;
> GROUP by 2 ;
> INTO CURSOR cDuplicates
>
>
>Then look for any items with dupcnt > 1