Did you try the # character for each digit? If using a text field for the number you might need this.# finds 3 but not 30## finds 30 but not 3 or 300#3 finds 53 and 43 but not 3
When I open the Known Bugs List database (https://www.dropbox.com/s/jt09b82i0xijbu3/FMP%20Bugs.zip) and use *8* as find criteria in the BugID field on the FMP Bugs layout, I find such records number 8, 18, 78, 81 to name just a few so I'm not sure why this didn't work for you.
What is the data type of this field?
Is the field formatted as an edit box or with a value list?
Is this a manual find or in a script?
What version of FileMaker are you using?
The field is a number edit box and I am using a manual find on Filemaker 13. One thing I have noticed is that the matching field in another table is set to text rather than number and that field performs the find without any problems. I could just switch the field to text but why is the find not working for a number edit box?
It's not clear at this point. The test that I originally ran was on a field of type number, but the file was open in FileMaker 14.
So I just ran this again on a file open in FileMaker 13. I had one field of type text and one field of type number with identical characters in both fields of the same record in each case.
using this find criteria (note that I am not using quotes here):
in either field produced identical results. I had three records with the values:
The find found the first two records and omitted the third whether I put the criteria in the number or the text field.
One more question: Is this field from the same table occurrence as that of the layout? (If you check "display data from" in the inspector, do you see exactly the same text to the left of :: as you see in "show records from" in layout setup?)
I've tried it again today with the * either side and it is now working. Thank you for your help.