Skip to contents

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.

Usage

not_ilike_escape(string, like_specifier, escape_character)

Arguments

string, like_specifier, escape_character

VARCHAR

Value

BOOLEAN

SQL examples

not_ilike_escape('A%c', 'a$%C', '$')