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