I think using the * is perfect. If the Street Name 123 Anywhere Street and I use *Anywhere Street then the code will compare to any data in the table that ends in Anywhere Street, no matter what comes before it. The only downside is if the user types Anywhere Street compared to St. correct?
Now that I understand what is going on let me code and see if i get it to work. I'll let you know. Great Lesson and thank you.