>I have a table with 5 fields and I'd like to get rid of the dup records base of 4 fields. The SELECT DISTINCT command doesn't work in this case because it compares the whole record.
>
>Any sugestions? Thank you in advance.
you can choose your criteria for your uniqueness check with the GROUP BY clause:
SELECT COUNT(*), * FROM Mytable GROUP BY Field1, Field2, Field3, Field4 HAVING COUNT(*) > 1
Erik Moore
Clientelligence