Beginner

234. LOWER Function

Learn how to convert text values into lowercase characters.

📘 Lesson 234 of 728 ⏱ 8 min 🎯 Beginner

The LOWER function converts alphabetic characters in a text value to lowercase.

Standardizing text to lowercase can make comparisons and matching more consistent.

Convert email addresses to lowercase for standardized reporting.

SQL 
SELECT
    LOWER(Email) AS StandardEmail
FROM Customers;

LOWER is useful for email normalization, text cleansing, searching, matching, and reporting.

  • LOWER converts text to lowercase.
  • It helps standardize text.
  • It is useful for email normalization.
  • It can improve consistent matching.
  • It can be combined with TRIM.
What does LOWER do?

LOWER converts alphabetic characters in a string to lowercase.

Why convert email addresses to lowercase?

It provides a consistent representation that can simplify matching and reporting.

Have you finished this lesson?

Introduction to SQL – All Lessons