Show/Hide Toolbars

Navigation: Appendices > String pattern matching

SQL-Wildcard expressions

Scroll Prev Up Next More

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

© 2021 AFRY Austria GmbH, www.redbex.com