Try Opteryx

Case-insensitive like

Returns true when the left string matches the SQL ILIKE pattern on the right without case sensitivity.

Category: comparison

SQL symbol: ILIKE

Syntax

sql
<haystack> ILIKE <pattern>

Parameters

  • <haystack> — The value tested against the pattern. Accepts nvarchar, varbinary, varchar.
  • <pattern> — A SQL LIKE pattern, matched without regard to case: % matches any run of characters, _ matches exactly one. Accepts nvarchar, varbinary, varchar.

Returns

boolean

Examples

sql
SELECT name FROM $planets WHERE name ILIKE 'ma%';
Mars
sql
SELECT 'ABC' ILIKE 'abc', 'ÉCOLE' ILIKE 'école';
true | false

Signatures

  • nvarchar ILIKE nvarchar → boolean
  • nvarchar ILIKE varbinary → boolean
  • nvarchar ILIKE varchar → boolean
  • varbinary ILIKE nvarchar → boolean
  • varbinary ILIKE varbinary → boolean
  • varbinary ILIKE varchar → boolean
  • varchar ILIKE nvarchar → boolean
  • varchar ILIKE varbinary → boolean
  • varchar ILIKE varchar → boolean

Notes

Case folding is ASCII-only: 'ABC' ILIKE 'abc' is true, but 'ÉCOLE' ILIKE 'école' is FALSE - accented and other non-ASCII letters are compared as written. Where that matters, fold explicitly with a function instead.

See Also