I have a text field that consists of two numbers, then three letters, then three numbers that is part of a barcoding system. The three letters in the middle represent the class of object that the barcode refers to. This format is part of a legacy system that I am stuck with.

My users want to find all records in a particular class by simply entering the three letters in the barcode field in a find. Such finds do not produce any matches, even though the three letters are in the field. It must be something about the number, text, number, arrangement that makes FM lose its ability to find on partial data in a text field.

I realize that I could separate out those three letters into a separate field, but do not really want to have to train all my users how to use this new field.

Is there a way to get FM to find all records that have the middle three letters matching a find entry that consists only of these three letters?

Try entering a * before and after the letters you want to search on.

*abc*

Thanks - I knew it was someting simple like that.