>Hi,
>I am new to VFP8, I have a table and have 1000 records, contain only
>one field, the field contain the invoice no.
>
>How can I use SQL statement to find out the duplicate invoice no. from
>the table ?
>Please advice.
>
>Thanks
>Derek Yim
select InvoiceNo, count(*) as Dups from yourtable group by InvoiceNo ;
having Dups > 1 into cursor Dups
If it's not broken, fix it until it is.
My Blog