User's Manual

Advanced Queries
21.1 Advanced Queries
21
21-7
Figure 21.4
In this example, you use the percent (%) wildcard since you are not sure how many
characters are in the missing parts of the description. Conversely, if you wanted to pull up
a query list showing every instrument that did not have “pressure” and “valve” in its
description, then you would perform the same steps, but instead you would insert “NOT
LIKE” into the Operation field.
An example where the _ wildcard would be useful is as follows:
1. Imagine that all of your Instrument ID’s begin with “INST” followed by a dash and
two numeric characters, starting with “01”. Using the underscore ( _ ) wildcard, you
could pull up a query list showing all instruments whose ID’s are in the “21’s”. To do
this you would perform the following steps:
2. Select Instrument ID from the Selection Field Name drop-down list.
3. Choose “LIKE” from the Operation drop-down list.
4. Enter “INST-2_” into the Selection Value field.
5. Finally, click the Add To Selection Criteria
button to move it into the Selection
Criteria During Query Execution box. Your screen will look like the one shown in
Figure 21.5 below.
6. Click the Execute
button to generate a query list showing ten instruments, beginning
with “INST-21” and ending with “INST-29”.