Microsoft KB Archive/41521

= Microsoft Knowledge Base =

File Doc Err: Using the &quot;<=&quot; Operator in the Find Command
Last reviewed: October 27, 1994

Article ID: Q41521

Summary:

The &quot;Microsoft File for the Apple Macintosh&quot; manual states on page 95 that when you search the text field &quot;name&quot; using the Find command, the search criteria &quot;<=M&quot; finds all records with &quot;name&quot; entries that begin with the letters &quot;A&quot; through &quot;M&quot;. This may be misleading. The criteria &quot;<=M&quot; will find all entries up to and including the single letter &quot;M&quot;. It will not find other entries that begin with &quot;M&quot;, such as &quot;MA&quot;.

This functionality is consistent with the use of the &quot;=&quot; and &quot;>=&quot; operators. &quot;=M&quot; will return the entries that only contain the single letter &quot;M&quot;. &quot;>=M&quot; will find all entries that begin with &quot;M&quot; through &quot;Z&quot;.

Typing just the letter &quot;M&quot; with no operator into a Find field will return all entries that begin with the letter &quot;M&quot;, such as &quot;M&quot; and &quot;Max&quot;.

To find all records where the &quot;name&quot; field begins with the letter &quot;M&quot;, the search criteria must specify &quot;<=N&quot;.