Beginner

305. LOWER Function

Learn how to convert text values into lowercase characters.

📘 Lesson 305 of 728 ⏱ 8 min 🎯 Beginner

The LOWER function converts alphabetic characters in a string to lowercase.

Text stored in different capitalization formats can cause inconsistent analysis. LOWER helps standardize text values.

Convert customer email addresses to lowercase.

SQL 
SELECT
    CustomerID,
    LOWER(Email) AS StandardEmail
FROM Customers;

LOWER is useful for data cleaning, email normalization, case-insensitive comparisons, and standardizing text.

  • LOWER converts text to lowercase.
  • It helps standardize text.
  • It is useful for email normalization.
  • It can support comparisons.
  • Non-alphabetic characters are generally unchanged.
What does LOWER do?

LOWER converts alphabetic characters in a string to lowercase.

Why use LOWER during data cleaning?

It helps standardize text values that may have inconsistent capitalization.

Have you finished this lesson?

Introduction to SQL – All Lessons