Hi!
Select mailcode, count(mailcode) from MyTable group by mailcode having count(mailcode)>1
>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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.