Not case-insensitive like
Returns true when the left string does not match the SQL ILIKE pattern on the right.
Category: comparison
SQL symbol: NOT ILIKE
Syntax
sql
<haystack> NOT ILIKE <pattern>Parameters
<haystack>— The value tested against the pattern. Acceptsnvarchar,varbinary,varchar.<pattern>— A SQL LIKE pattern, matched without regard to ASCII case. Acceptsnvarchar,varbinary,varchar.
Returns
Examples
sql
SELECT name FROM $planets WHERE name NOT ILIKE 'ma%' LIMIT 3;Mercury
Venus
Earth
Signatures
nvarchar NOT ILIKE nvarchar→ booleannvarchar NOT ILIKE varbinary→ booleannvarchar NOT ILIKE varchar→ booleanvarbinary NOT ILIKE nvarchar→ booleanvarbinary NOT ILIKE varbinary→ booleanvarbinary NOT ILIKE varchar→ booleanvarchar NOT ILIKE nvarchar→ booleanvarchar NOT ILIKE varbinary→ booleanvarchar NOT ILIKE varchar→ boolean
Notes
Case folding is ASCII-only, exactly as for ILIKE.