Anyway to group counts in MSSQL rows-columns which have similar names. For eg. Cisco, Cisco Systems & Cisco Systems Inc.?
===

I'm trying to count devices by MAC vendors prefixes on a network. The results from the queries I'm getting back from the database have the counts but the names of vendors differ slightly like Cisco, Cisco Systems & Cisco Systems Inc. Is there anyway to add all of these and represent them as just Cisco ? 

I'll be displaying this information on a web front end. I am using PHP to retrieve data from this database.