Hi
try that if you are using MSSQL
SELECT name, SUBSTRING(interface, 1, 13) AS interface, COUNT(SUBSTRING(interface, 1, 13)) AS aCount
FROM ***NAME of the TABLE***
GROUP BY name, SUBSTRING(interface, 1, 13)
ORDER BY name, aCount
this will return you...