>Hi all
>
>I looking for some way to detect in a table (using a query) in VFP 3.0
>how to detect duplicate records..
>
>Thanks in advance


Determine what makes a record unique, say field1, field2, field3, then:

SELECT field1, field2, field3, count(*) as count ;
from MyTable ;
group by field1, field2, field3 ;
having count > 1 ;
into cursor cdupes