• Use the LIKE condition to perform wild card searches of valid search string values.
• Search conditions can contain either literal characters or numbers:
– % denotes zero or many characters.
– denotes one character.
SELECT first_name
FROM employees
WHERE first_name LIKE ’S%’;