[NOT] LIKE
Welcome to our Knowledge Base
Documentation | Blog | Demos | Support
< All Topics
Print
[NOT] LIKE
0 out of 5 stars
5 Stars | 0% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
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
Updated
ByJason Lee
Was this article helpful?
0 out of 5 stars
5 Stars | 0% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
5