i have two fields, field1 which is an integer and field2 which is text, how do i select all documents in a table that have duplicate values or is not unique and sorted based on their corresponding field1 integer values?
quote: select fld from tbl group by fld having count(*) > 1 ?
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.