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