>I have a table containing approximately 2200 record and I want to check to see if I have any duplicate records for the field called mailcode. Is there any way I can do this using SQL. Thanks
Try
SELECT Mailcode, COUNT(*) AS Numcodes;
FROM alias;
GROUP BY Mailcode;
INTO CURSOR foo
Where Numcodes is greater than 1 there are duplicates.
George
Ubi caritas et amor, deus ibi est