go and change that field from text to number !
Thank you Daniele.
But, I need to keep the data type as Text. I tried another record with 1a and it also return when search criteria is 1. Beside circumcising the problem, any idea how FileMaker works?
So you haven't only numbers inside that field !
... and you need it as a text field.
The search must be do in this way ( with a script ):
Enter Find Mode [ ]
Set Field [ yourField ; "=1" ]
= standing for "exact match"
or by hand, entering that symbol ( = ) before the invoice number to search for.
Got it! Thanks.