I have two tables, each with a text field. One field has text that is a modified version of the other table field's text.
Example:
Table 1
"RD S (LA VETA AVE)"
Table 2
"LA VETA AV"
1. I want to find records in Table 2 that has text present.
2. Match that text to Table 1.
3. Return a table...