Beginner

95. UPPER Function

Learn how to convert text values to uppercase using the UPPER function.

📘 Lesson 95 of 728 ⏱ 7 min 🎯 Beginner

The UPPER function converts alphabetic characters in a string to uppercase. It is commonly used for formatting and standardizing text values.

Text stored in databases may have inconsistent capitalization. Converting values to a common case can make reporting and data preparation easier.

Employee department values such as 'finance', 'Finance', and 'FINANCE' can be displayed in uppercase for consistent presentation.

SQL 
SELECT
    UPPER(Department) AS DepartmentName
FROM Employees;

UPPER is useful for data cleaning, standardization, report formatting, search preparation, and category normalization.

  • UPPER converts text to uppercase.
  • It is commonly used for formatting.
  • It can help standardize text presentation.
  • It does not normally modify the stored value unless used in an UPDATE.
  • Function behavior can vary slightly between database systems.
What does UPPER do?

UPPER converts alphabetic characters in a text value to uppercase.

Why use UPPER in data analysis?

It can help standardize text formatting and make categories easier to compare or display consistently.

Have you finished this lesson?

Introduction to SQL – All Lessons