| |
Wildcard
Characters and Comparison Operators
In our first
query example, a record would only be selected if the field "City"
contained exactly Chicago. However, an exact match may be too restrictive
of a search. Therefore, you can use either WILDCARD CHARACTERS or
COMPARISON OPERATORS to assist you in finding close matches. The
following two tables show the symbols used for each of these, and
examples of each.
|
WILDCARD
CHARACTERS
|
| SYMBOL
& USAGE |
WHAT
IT DOES |
SAMPLE
|
| M*
|
Finds
all records that begin with M, no limit on extra characters
|
Murphy,
McCall, Martin |
| *M
|
Finds
all records that end with M, no limit on extra characters |
Tim,
mom, I'm |
| *M*
|
Contains
the letter M anywhere within it |
Time,
McDonalds, gemstone |
| ?
|
Single
character that can represent any other character |
F?nd:
Find, Fund, Fend, Fond |
| ??
|
Two
characters that can represent any two consecutive characters
|
F??d:
Food, Ford, Fred |
|
COMPARISON
OPERATORS
|
| SYMBOL
|
WHAT
IT REPRESENTS |
| >
|
Greater
Than |
| <
|
Less
Than |
| >=
|
Greater
Than or Equal To |
| <=
|
Less
Than or Equal To |
| <>
|
Not
Equal To |
(NOTE:
Greater Than or Equal To, Less Than or Equal To, and Not Equal To
must be typed as shown, since there are no single characters to
represent them)
The following
example will look for all products that have the word "press"
in the Product Brand field.
Here is the
resulting query.
|
