SQL Wildcard Characters
A wildcard character is used to substitute one or more characters in a string.
Wildcard characters are used with the
LIKE operator. The
LIKE
operator is used in a
clause to search for a specified pattern in a column.
WHERE
Example
Return all customers that starts with the letter ‘a’:
SELECT * FROM Customers
WHERE CustomerName LIKE 'a%';