Logical function returns
TRUE if expression matches the defined pattern, and
text expression: Text created using text functions, text fields or constants.
LIKEoperator is used to match text values against a pattern using wildcards. If the search expression can be matched to the pattern expression, the
LIKE operator will return
There are two wildcards used in conjunction with the
- The percent sign (
- The underscore (
The percent sign represents zero, one, or multiple numbers or characters. The underscore represents a single number or character. These symbols can be used in combinations.
If either of these two signs is not used in conjunction with the
LIKE clause, then the
LIKE acts like the equals operator.