1 of 1 people found this helpful
you can search for *420339608* and that should pull it up. * is the operator for zero or more characters, and will allow you to pull up partial matches with missing characters on any side of your string.
Mike's response works perfectly for a "pattern-count" type of search. If you want to be sure that the final numerals are exact matches, the trailing * at the right end should probably be removed so the scripted search is testing just the final characters rather than a pattern-count type of match for anywhere in the string. That would allow users to enter as many or few of the final characters as they choose, realizing that the fewer characters entered, the larger the likely found set.
Thank you both! I was aware of that operator but hadn't really thought about how to automate that into the search (nor had I thought about adding the * after the string.
I thought of a way to add this to my "Find" script though and it works beautifully. Thank you both! I did decide to omit the ending * for now, but will keep that in mind if I need it in the future.
FileMaker's default IS a begins-with and can be on any word in a multi-word field value. Study the wild cards and how they can be combined for more precise results.
-- sent from my iPhone4 --
Glad it worked, I only suggested it on both ends to make sure you knew it could be used on both sides.