Beginner

96. LOWER Function

Learn how to convert text values to lowercase using the LOWER function.

📘 Lesson 96 of 728 ⏱ 7 min 🎯 Beginner

The LOWER function converts alphabetic characters in a string to lowercase. It is commonly used for text normalization and consistent formatting.

Text values may be stored with inconsistent capitalization. LOWER can help create standardized representations for analysis and comparisons.

Email addresses or department names can be converted to lowercase to create a consistent representation.

SQL 
SELECT
    LOWER(Email) AS StandardEmail
FROM Employees;

LOWER is useful for data cleaning, email normalization, text comparison, search preparation, and report formatting.

  • LOWER converts text to lowercase.
  • It is useful for text normalization.
  • It can help standardize email or category values.
  • It does not normally change stored data by itself.
  • It can be combined with other string functions.
What does LOWER do?

LOWER converts alphabetic characters in a string to lowercase.

Why use LOWER on text data?

It helps standardize text values and can make comparisons and data preparation more consistent.

Have you finished this lesson?

Introduction to SQL – All Lessons