I have a table that has over 5.2 million rows, so I can't edit that a lot. Part of the table is a list of addresses. However, there isn't consistency to how the addresses are. I end up getting a list of addresses that need the information from the main table. Is there a way to create an approximate match. I am okay if I have to manipulate the query results.
Main Table - 123 N Main Street
Request Table - 123 Main St.
I am wanting to not have to do a manual query. Currently I am doing Like "123*" and Like "*Main*"... but my request table is getting to be over 100 rows.