SQL like wildcard character essay

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 all three-letter, end-of-Im names (for example, Jim, Tim).

? WHERE LastName like '%stein ' can find all employees whose last name ends with Stein.

? where LastName like '%stein% ' can find all employees in the surname, including Stein, anywhere in the family name.

? WHERE FirstName like ' [Jt]im ' can find three-letter names ending with IM and starting with J or T (that is, Jim and Tim only)

? WHERE LastName like ' m[^c]% ' can find all surnames starting with M, followed by (second) letter not C.

Querying for data with single quotes

For example, to check data containing ' 123 ' (including single quotes)

Where field like '% ' ' 123 '% ' (123 not double quotes are two single quotes equivalent to ' escaped ')

SQL like wildcard character essay