• Try this:

    SELECT c1.*

    FROM [CPACONTACTS].[dbo].[CPACONTACTS2] c1

    INNER JOIN (SELECT COMPANY

    FROM [CPACONTACTS].[dbo].[CPACONTACTS2]

    GROUP BY COMPANY

    HAVING COUNT(*) > 1) c2

    ON c1.COMPANY = c2.COMPANY

    ORDER BY c1.COMPANY

    EDIT: added ORDER BY clause to my original code. Makes it easier to see the dups.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.