Don’t forget alltrim!
When comparing two fields or looking for one field inside another, use alltrim to make sure that no spaces get in the way of finding all matches.
|Field 1||Field 2|
|1234||1234 Fake Street|
Try to find Field 1 in Field 2
You can try find(Field1,Field2)
This will not work in the examples above if a space or multiple spaces are included in front or behind the visible text. Trust me, they are there. I put them in.