Assumed that field name is ID and that it is the first 6 characters is the portion you are looking at

I loaded it all into a temp table and used:

Select ID from #Temp where Left(id,6) IN (Select left(id,6) from #Temp group by left(id,6) having count(*) > 1)