SQL like 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.
 

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.