Search error in combination with letter "M" ?

[Christer]

I recive wrong search result when searching textfield as described below.

Register contains following records in standard textfield:

MSG 85/731 MAXIMO M

MSG 85/731 MAXIMO M TRUCK

MSG 85/731 MAXIMO L

MSG 85/731 MAXIMO K

MSG 85/731 MAXIMO K TRUCK

MSG 85/731 MAXIMO J

MSG 85/731 MAXIMO L TRUCK

MSG 85/731 MAXIMO J TRUCK

When seraching for MSG 85/731 MAXIMO M the result shows all 8 records !!

When searching for MSG 85/731 MAXIMO L or MSG 85/731 MAXIMO J or MSG 85/731 MAXIMO K, I get the correct result (2 found records).

When searching for MSG 85/731 MAXIMO TRUCK I get 4 found records. (All that contains truck).

This is made i a Filemaker 4.1sv1 (swedish). The register contains no other fields and I don't use any optinals in the search.

Any ideas ?

[ September 12, 2001: Message edited by: Christer ]

[ September 12, 2001: Message edited by: Christer ]

[Kurt Knippel]

This is a basically due to the way that Filemaker treats searches when only search ciiteria is entered. In fact most search engines will return the same result set.

By default all Finds are setup as "OR" or "ANY" criteria. Meaning that Filemaker will return all the records that match on any of your words.

There are many ways to get Filemaker to be more specific in its finds. Using the == operator will cause Filemaker to look for an EXACT match, as will enclosing your criteria in "", as this causes Filemaker to treat everything within as a single word.

There are lots of other operators as well, look in the Help for an explanation of what each one does.