Using wildcards (Like -operator)
When a value supports wildcards (Like -operator) you can use the following special characters. All of the example below match the string ‘example 1’.
|*||Zero or more characters||*amp*1|
|?||Any single character||e?ample 1|
|#||Any single digit (0–9)||example #|
|Any single character in ||e[xyz]ample 1|
|Any single character not in ||e[!abc]ample 1|
To match the special characters left bracket (
[), question mark (
?), number sign (
#), and asterisk (
*), enclose them in brackets. The right bracket (
]) cannot be used within a group to match itself, but it can be used outside a group as an individual character.