>>I thank all in advance for any help. I have been asked to provide a screen lookup, or browse window where the user would like to filter and show only the records where a specific field has duplicates. Is it possible to do in an SQL, or do I have to write a function to extract the duplicates first, then simply browse those?
>
>Hi Carmen,
>If you want only display duplicates than

SELECT * FROM mytable ;
>  WHERE KeyField1 IN ( ;
>    SELECT KeyField1 FROM mytable GROUP BY 1 HAVING COUNT(*) > 1 ) ;
>  INTO CURSOR crsDups

Sergey
Thank you for your quick and helpful response. With modification to order the cursor by a key field, the sql command works perfectly. Again, many thanks.

Regards
Carmen