*

Placed anywhere in a string, returns records containing the string or containing the string plus any additional characters at the position at which the asterisk appears, including a space. For example, *rang* finds arrange, arranged, orange, orangutan, range, ranges, ranging, rang, strange, stranger, strangest, strangle, wrangle, and so on. It is not necessary to put a wildcard at the end of the word; for example, Siebe will return Siebel.

?

Placed anywhere in a string, returns records containing the characters specified in the string, and also containing any single character at the location of the question mark. For example, ?rag finds brag, crag, or drag, but not bragging. t?pe finds type and tape, but not tripe. To find a question mark, precede the question mark with a backslash (\?).