SQL like wildcard usage

_ 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.

For more information about how to use the like character and add the SQL wildcard, see:

A. Like 'mc % 'searches all strings starting with MC (for example, mcbadden ).

B. Like '% Inger' searches all strings ending with the letter Inger (such as ringer,

Stringer ).

C. Like '% en %' searches for all strings containing letters en at any position (such as Bennet,

Green, mcbadden ).

D. Like '_ heryl' searches for names of all six letters ending with the letter heryl (for example, Cheryl,

Sheryl ).

E. Like '[Ck] ARS [EO] n' will search for the following strings: Carsen, Karsen, Carson, and karson

(Such as Carson ).

F. Like '[M-Z] Inger' will search for any single word ending with string Inger from m to Z

All names starting with the parent (such as ringer ).

G .. like'm [^ C] %' will search for all names starting with m, and the second letter is not C (such

Macfeather ).

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 find 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 surnames starting with M and ending with (second) Letters not C.