DuckDB function not_ilike_escape — not_ilike

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

Arguments

string: VARCHAR
like_specifier: VARCHAR
escape_character: VARCHAR

Examples

if (FALSE) { # \dontrun{
not_ilike_escape('A%c', 'a$%C', '$')
} # }