SELECT COUNT(Sin) as DupCnt, Sin + DTOS(Add_date) + Add_time AS pKey ;
  FROM SheenaTable ;
  GROUP BY pKey;
  INTO CURSOR cDuplicates ;
  HAVING DupCnt > 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