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 _.|
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.