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