I guess Filemaker is reading the # as an Operator for any one digit, how do I get around that issue?
A character with special meaning, such as the find operators recognized by FileMaker Pro:@, *, #, ?, !, =, <, >, " (escape next character)Any character with special meaning such as the # sign you must use \ in front of the sign. Example Black \#2#2 without the \ will find 12,22,32,42,52,62,72,82,92. The # is the wild symbol for 1 - 9
Put the search text in quotes and any "find operators" inside the quotes will be treated as characters instead of operators.
In otherwords, use:
as your criteria.