SQL LIKE wildcard

Wildcard description

_ Match with any single character

% Matches a string that contains one or more characters.

[] Matches any single character in a specific range (for example, [a-f]) or a specific set (for example, [abcdef.

[^] Matches any single character other than a specific range (for example, [^ a-f]) or a specific set (for example, [^ abcdef.

Example:

• WHERE FirstName LIKE '_ im' can find names ending with im (for example, Jim and Tim) with all three letters ).

• WHERE LastName LIKE '% stein' can be used to locate all employees whose names end with stein.

• WHERE LastName LIKE '% stein %' can be used to locate all employees whose surnames include stein.

• WHERE FirstName LIKE '[JT] im' can be found in names with three letters ending with im and starting with J or T (I .e., only Jim and Tim)

• WHERE LastName LIKE'm [^ c] %' can find all the names starting with m and ending with (second) Letters not c.