• Hi terryphone,

    If the data is reliably as you listed (the data is alphanumeric and the "like" IDs are always 6 numeric digits with or without a letter appended), you should be able to get your list from the following query:

    SELECT ID --I'm assuming the column name is ID, substitute the true column name

    FROM TableName t1 --I'm giving your table this generic table name, substitute the true table name

    WHERE EXISTS (

    SELECT *

    FROM TableName t2 --substitute the true table name here as well

    WHERE LEFT(t2.ID,6) = LEFT(t1.ID,6) --substitute the true column name here as well

    AND t2.ID <> t1.ID

    )

    ORDER BY ID

    Hope that helps.

    --Doug