ILIKE_NONE()

All functions > COMPARISON > ILIKE_NONE()

TRUE if the string matches ILIKE for no pattern in an array.

Signatures

Returns: TRUE, FALSE, or NULL following three-valued logic for NULL inputs or pattern elements

ILIKE_NONE(expr1: VARCHAR, patterns: ARRAY(VARCHAR), [escape: VARCHAR]) → BOOLEAN

Notes

• Keyword form: ILIKE ANY (pat1, pat2, …) (and ALL / NONE), optional ESCAPE escape; callable / chained forms use ARRAY(...) / ARRAY[...] and an optional third escape argument
• Wildcards % and _ in each pattern
• Case-insensitive ILIKE per pattern where the dialect supports it; otherwise lowercasing is used in translation
• Same ANY / ALL / NONE rules as LIKE_* on arrays
• NULL expr1 or NULL patterns → NULL
• BigQuery: this form is not translated (NOT_SUPPORTED)

Related operators

• LIKE multiple

Examples

ILIKE_NONE — functional call

SELECT
    f1 := ILIKE_NONE('Hello', ARRAY['%z%']) -- `ILIKE_NONE(expr, patterns)` matches keyword `ILIKE NONE`
;

ILIKE_NONE — chained

SELECT
    f1 := ('Hello').ILIKE_NONE(ARRAY['%z%']) -- Receiver is the string; argument is the pattern array
;