LIKE
condition is used to specify a search for a pattern. The string_expression
must have a string value. The pattern_value
is a string literal or a string-valued input parameter in which an underscore (_) stands for any single character, a percent (%) character stands for any sequence of characters (including the empty sequence), and all other characters stand for themselves. The optional escape_character
is a single-character string literal or a character-valued input parameter (i.e., char or Character) and is used to escape the special meaning of the underscore and percent characters in pattern_value
.
like_expression ::= string_expression [NOT] LIKE pattern_value [ESCAPE escape_character]
@see LikeExpression @version 2.4 @since 2.4 @author Pascal Filion
|
|
|
|