Using the LIKE Condition

Use the LIKE condition to perform wildcard 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%' ;