Which operator is the case-insensitive version of LIKE?

Which operator is the case-insensitive version of LIKE?

• A. LIKE
• B. BETWEEN
• C. IN
• D. ILIKE

Answer: (D)

Pattern matching with wildcard characters uses the LIKE operator, but in many databases LIKE is sensitive to case. The way to perform the same kind of matching without regard to case is to use an operator designed for that purpose: it mirrors LIKE’s syntax and wildcards while ignoring whether characters are uppercase or lowercase. This means a pattern like 'abc%' will match strings starting with any case variation of "abc," such as "ABC" or "Abc." The other operators shown serve different purposes—BETWEEN checks if a value falls within a range, and IN checks membership in a set—so they aren’t used for case-insensitive pattern matching.

Pattern matching with wildcard characters uses the LIKE operator, but in many databases LIKE is sensitive to case. The way to perform the same kind of matching without regard to case is to use an operator designed for that purpose: it mirrors LIKE’s syntax and wildcards while ignoring whether characters are uppercase or lowercase. This means a pattern like 'abc%' will match strings starting with any case variation of "abc," such as "ABC" or "Abc." The other operators shown serve different purposes—BETWEEN checks if a value falls within a range, and IN checks membership in a set—so they aren’t used for case-insensitive pattern matching.