I understand in Find Mode that if I enter in a field called
ContactCompany, <D , Filemaker will return all ContactCompany names
that begin with letters less than D (#, A, B, C). But this is not what
I get. Can anyone explain what I am misunderstanding here?

Thanks

Searching in a FileMaker field will return results based on any word in
that field being a match. So if you search for 'Jo', then you will get
Joe Smith as well as Davey Jones. Likewise, searching for <D will
return all records where any word starts with a character less than D.

If you want a lesser-than search to work only on the first word of a
field, then you will need to create a stored/indexed calc =
leftwords(OrigField;1) and then search on that.


buck.matthew74 [at] yahoo.com wrote:
> I understand in Find Mode that if I enter in a field called
> ContactCompany, <D , Filemaker will return all ContactCompany names
> that begin with letters less than D (#, A, B, C). But this is not what
> I get. Can anyone explain what I am misunderstanding here?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Member, FileMaker Business Alliance