[NOT] LIKE
Matches an expression to a pattern.
Syntax
expression [NOT] LIKE pattern
Parameters
| 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 _. |
Return Value
Logical.
Comments
A LIKE comparison is logically true if expression matches patterns.
A NOT LIKE comparison is logically true if expression fails to match pattern.
Example
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.
See Also