I have two foxpro tables that I am trying to compare. The purpose is to identify a string of words that is potentially in the other table.
For example: in my first table I have a striped number
Striped number (table 1) Big Description (table2)
I want to find all items where the striped number in table 1 exists anywhere in table 2. What is the best way to do this?