Very new to SQL and I learn by example but cannot find anything like this after tons of searching. I have an Excel workbook of software application names and versions. Many have the same 'root' name but different version number. e.g. root = "McAfee VirusScan" sheet columns... APP NAME -- VERSION # -- MANUF -- INSTALL COUNT I think a View might be best(?) but no idea how to code it. The View needs to SUM the INSTALL COUNTs for all similar APP NAMEs & VERSIONs(similar determined by using first few characters or something - options here?) example: McAfee VirusScan v1.01 21259 McAfee VirusScan v3.20 14234 ... There are thousands of APPs. I will not know all the possible versions. Anyone do this before and have some example code or could help? Thx in advance!