Beware that performance is not good, and it would be "better" if database design of Table2 had the Prefix in a separate column to the Suffix, as the performance of a straight equals join would be better.
I'm only raising this just so you are aware (if you weren't already 
), back in the real world we have to do what we have to do ...