UPPER and LOWER

Convert text to upper or lower case.

UPPER converts text to uppercase, LOWER to lowercase. They are used for consistent search and comparison.

SELECT UPPER(name) AS upname FROM customers;

This query converts customer names to uppercase.

UPPER(name) AS upname is selected from customers.

UPPER and LOWER — details

To bypass case-sensitive search you write WHERE UPPER(name) = 'AYSE'. Some databases offer ILIKE for case-insensitive matching.

Select name in uppercase from customers.

Show example solution

SELECT UPPER(name) AS upname
FROM customers

Lowercase

SELECT ____(name) FROM customers;

Show answer

SELECT LOWER(name) FROM customers;

Next lesson: LENGTH