>>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