Monthly Archives: March 2012

Tips & Tricks #13

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.
For example
Field 1 Field 2
8695 000-99-8695
Jack Jackson Huflbug
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.

This will work though!