Free E-Books

Access can use the asterisk any number of times in an
example expression. The pound sign (#) stands for any single digit (0-9) found in the same position
as the pound sign. The brackets ([]) and the list they enclose stand for any single character
that matches any one character in the list located within the brackets. Finally, the exclamation
point (!) inside the brackets represents the Not word for the list??”that is, any single character
that does not match any character in the list within the brackets.
TABLE 5-6
Wildcards Used by the Like Operator
Wildcard Purpose
? A single character (0??“9, Aa??“Zz)
* Any number of characters (0??“ n)
# Any single digit (0??“9)
[list] Any single character in the list
[!list] Any single character not in the list
TIP TIP
183
Using Operators and Expressions in Access 5
These wildcards can be used alone or in conjunction with each other. They can even be used several
times within the same expression. The examples in Table 5-6 demonstrate how you can use
the wildcards.


Pages:
496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520