3.6

The SQL LIKE operator is case sensitive (in most systems), but the lower() function on strings can be used to perform case-insensitive matching. To show how, write a query that finds departments whose names contain the string “sci” as a substring, regardless of the case.


SELECT dept_name
FROM department
WHERE LOWER(dept_name) LIKE '%sci%'