DuckDB function not_like_escape — not_like

Returns false if the string matches the like_specifier (see Pattern Matching) using case-sensitive matching. escape_character is used to search for wildcard characters in the string.

Usage

not_like_escape(string = VARCHAR, like_specifier = VARCHAR, escape_character = VARCHAR)

Arguments

string: VARCHAR
like_specifier: VARCHAR
escape_character: VARCHAR

Value

BOOLEAN

SQL examples

not_like_escape('a%c', 'a$%c', '$')