Finding the Contents of One Field in Ano

I have been trying to find a way to compare a text field FieldAA in Table A to see if the data in text field FieldBB in Table B contains the string in FieldAA.

I am searching FieldBB for the value of each occurence of FieldAA. This value will change from record to record and I already know that the data in the two fields will seldom, if ever, be identical so the usual FieldAA = FieldBB statement will result in failure.

I have been trying to use the “Like” statement with the “*”wildcard,but have not been able to figure out a way to make either one work in a statement that includes a fieldname rather than a literal value.

Any ideas on if and how this can be done would be most appreciated.