لطفا منتظر باشید ...
Using Search Operators
FileMaker uses search operators to extend the power of Finds. "And" and "Or" searches are "big gun" tools that allow you to pull out large categories of data based on field names. Search operators are more like precision instruments. Using them, you can search for information that's more deeply buried in the database records. For example, mistyped entries, variant spellings, or a checkbook discrepancy in the February balance can all be located with a well-chosen search operator.The range operator is most often used to find a series of dates or numbers, but it's equally useful for an alphabetic search. In fact, most operators allow you to use letters in the same manner as numbers in finds. Try this with the range, greater than, and less than operators to search for items in different parts of the alphabet.
To use a search operator in a data search
1 .Switch to the layout you want, then choose View > Find Mode (Control+F/Command+F).2 .Click the field you want to search. Type the first letter of the range.3. In the status area on the left, click the Symbols arrow to choose the range operator from the drop-down menu (Figure 5.4). Type the last letter of the range, then click Find.
Figure 5.4. You don't have to search for operators on the keyboard; they're all listed in the Find status area.
Figure 5.5. The range operator can be used to find ranges of letters, as well as dates or numbers.
TipsAnother way to search for a range that starts at the beginning of the alphabet is to type
M in the Last Name field (use 
N for the end of the alphabet).If you need to find an entry that includes one of the search operators (like an amper sand) place quotes around it. Quotes change an operator into a plain text character for search purposes (Figure 5.6). The combination of operators in this example will find all the entries with an ampersand anywhere in their Paid To field (Figure 5.7).Figure 5.6. To find all entries that contain an ampersand (&) or other search operator, place quotes around the operator.
[View full size image]
Figure 5.7. By combining the "any character" wildcard (*) with the ampersand in quotes, you can find all entries with an ampersand in them no matter where in the field the ampersand appears.
[View full size image]
Search Operators
Finds values less than or equal to the search criteria>Finds values greater than the search criteriaFinds values greater than or equal to the search criteria=Finds values that exactly match anywhere in the field…Finds values that fall within a range (e.g., 1/1/2000…1/31/2000)!Finds records that have duplicate values in a field//Finds records that have today's date in the field?Finds records that have an invalid character in a date field@Substitutes for a single character in search criteria (J@nes will find Jones, Janes, and Junes)*Substitutes for any number of characters in search criteria (J*nes will find Jones, Jarones, and Jinones)"Finds records that match criteria in quotes ("John Jones Jr.")~Ignore this one unless you're Japanese==Finds values that are an exact match for the total field contents, not just a part of the field
