Thanks again Ray,
That worked once I changed the join from "AND" to "OR".
I noticed that if I commented out 2 of the searches, it would work to find the one search, whether it was the begins with our ends with. It would find records that matched that position. Then it dawned on me, it was looking for all of those conditions. I changed it to "OR" and it works. It's doing exactly what I need it to. Appreciate the help.