>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.