Just the three rows.  Some accounts are sent in by our clients with prefixes and/or suffixes and some of the accounts in our Data Base also have prefixes and/or suffixes.  A...

I do not know enough TSQL to code the loop needed to generate to create the three rows from 1 row as shown in my example.