If you use operators that perform LIKE comparisons (is like and is not like) within an expression token, you can use wildcards within the comparison value in that token. A wildcard acts as a substitute for a character or string of characters. The wildcards have the same behavior and syntax as the ANSI SQL LIKE comparison operator.
| Wildcard | Meaning |
|---|---|
| % | Any string of zero or more characters. |
| _ (underscore) | Any single character. |
| [ ] | Any single character within the specified range (for example, [a-f]) or set (for example, [abcdef]). |
| [^ ] | Any single character not within the specified range (for example, [^a-f]) or set (for example, [^abcdef]). |