SQL wildcard expressions provide simple but easy to understand and flexible means "matching" (specifying and recognizing) strings of text.
Wildcard character |
Description |
Example |
---|---|---|
% |
Any string of zero or more characters. |
%Name% matches AB Name as well as AB Name CD as well as Name1 %Name% does not math AB Nam CD %Name does not math Name CD |
_ |
Any single character. |
Feature _ matches Feature 1 as well as feature A |
[] |
Any single character within the specified range ([a-f]) or set ([abcdef]). |
Feature [12345] matches Feature 1, Feature 3 but not Feature 9 |
[^] |
Any single character not within the specified range ([^a-f]) or set ([^abcdef]). |
Feature [^A-M] matches Feature M to Feature Z but not Feature A to Feature M |