User's Manual
Searching for Records
Wildcard Searching
3
3-13
Number
For all operators except Approx, each of the specified field data elements
must meet the search criteria when compared against each of the search
criteria elements (by numerical value). The first field data element must meet
the search criteria when compared against the first element of the search
criteria, the second field data element must meet the search criteria when
compared against the second element of the search criteria, etc. Display
format characters are ignored (such as $, %, etc.) Blank data is less than 0,
which is less than 30, which is less than 250, etc. If any single field data
element does not meet the criteria of any search criteria element, or the field
data array differs in size from the search criteria array, the field data array
will not meet the search criteria.
For Approx, if any of the field data elements are within +
10% of any of the
search criteria elements, the entire array is considered to meet the search
criteria.
Example: Perform a search on an arrayed Number field, using the Approx
operator, given the following search criteria and field data:
Search Criteria Field Data
20
58
100
37
1119
102
The search would find the record containing the field data because one of the
elements in the field data is within +
10% of one of the search criteria
elements.
Pick
For all operators, each of the specified field data elements must meet the
search criteria when compared against each of the search criteria elements
(by the item’s location within the list). The first field data element must meet
the search criteria when compared against the first element of the search
criteria, the second field data element must meet the search criteria when
compared against the second element of the search criteria, etc. The item at
the top of the list of available choices is “less than” the item immediately
following it, etc.
If any single field data element does not meet the criteria of any search
criteria element, or the field data array differs in size from the search criteria
array, the field data array will not meet the search criteria.