>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