Locating Records Using Wildcards and Operators

You can use the asterisk (*) as a wildcard character in place of one or more letters. Using the asterisk widens your search. For example, you can type abb* in the Alpha Name column of the query-by-example line to view all records that begin with the letters abb. Or you can type *bb* in the query-by-example line to retrieve those records that contain the letters bb in the middle of the name. In addition, you can search for values in a set using operators. For example, in the Address Number column of the query-by-example line, type <87 to specify address numbers that are less than 87. Type <b in the Alpha Name column of the query-by-example line to specify names that begin with a. The following operators are valid in the query-by-example line:

< Less than

< = Less than or equal to

> Greater than

> = Greater than or equal to

! Not equal to

Each time that you enter values in a search, click the Find button to retrieve matching records.