>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