>>Hi everybody,
>>
>>I have a complex query to get duplicates. I want to change all records (using SCAN/ENDSCAN) in the main table except for the latest record in each group. I can write a procedural code, but I'm wondering if there is a way to get them by SQL?
>>
>>I guess the procedural code would be simpler anyway.
>>
>>Thanks in advance.
>
>Your message indicates SQL Server database - is that where the data is? If so, what version?

Nope, sorry. The data are in VFP table. Though I would be curious to get it working for SQL Server as well.