NOT_ILIKE()

All functions > COMPARISON > NOT_ILIKE()

Negated case-insensitive wildcard match.

Signatures

Returns: TRUE, FALSE, or NULL

NOT_ILIKE(expr1: VARCHAR, expr2: VARCHAR, [escape: VARCHAR]) → BOOLEAN

Notes

Opposite of ILIKE; same wildcards as LIKE.

Related operators

• LIKE multiple

Examples

NOT_ILIKE — functional call

SELECT
    f1 := NOT_ILIKE('Ab', 'z%') -- `NOT_ILIKE(expr, pattern)` matches keyword `NOT ILIKE`
;

NOT_ILIKE — chained

SELECT
    f1 := ('Ab').NOT_ILIKE('z%') -- Receiver is the string; argument is the pattern
;