[NOT] LIKE

Matches an expression to a pattern.

expression [NOT] LIKE pattern

expression	An expression that evaluates to a character string.
pattern	An expression that evaluates to a character string. Pattern must consist of combinations of letters, digits, symbols, and the special wildcard characters % and _.

Logical.

A LIKE comparison is logically true if expression matches patterns.

A NOT LIKE comparison is logically true if expression fails to match pattern.

compute Employees where LastName like “_a%n”

Processes all records whose LastName values are three characters or more, the second character being an a, and the last character being an n.

find Parts where PartNo like “_ _\_%”

Finds all parts whose part numbers have an underscore as the third character.

find Parts where PartDesc like “%\\%”

Finds parts whose part description contains a backslash.