SQL · Functions and expressions

lower() / upper()

Changes case for comparisons and display.

sqlRunnable example sql course

Syntax

lower(text)

Example

Open in the lab

SELECT lower('EduByte') AS lower_name, upper('EduByte') AS upper_name;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.