Wildcard
A wildcard is a special character used in data searches.
- A question mark (?) substitutes for a single character. For example, S?ASH matches SMASH
but not SPLASH.
- An asterisk (*) substitutes for a single character or string of consecutive characters.
For example, M*E matches MIKE and MOOSE.
- An equal sign (=) in the first position makes the search case-insensitive. For example,
=hold matches HOLD, Hold, and hold.