Beginner

197. UPPER Function

Learn how to convert text values to uppercase using SQL.

📘 Lesson 197 of 728 ⏱ 7 min 🎯 Beginner

The UPPER function converts alphabetic characters in a text value to uppercase.

Standardizing text capitalization helps improve consistency during reporting, comparison, and data cleansing.

Display all employee names in uppercase.

SQL 
SELECT
    UPPER(EmployeeName) AS EmployeeName
FROM Employees;

UPPER is useful for data standardization, matching, reporting, validation, and preparing consistent text output.

  • UPPER converts text to uppercase.
  • It is commonly used for standardization.
  • It can be used in SELECT expressions.
  • It can be combined with other string functions.
  • Function behavior may depend on database collation.
What does UPPER do?

UPPER converts alphabetic characters in a text value to uppercase.

Why use UPPER in data analysis?

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

Have you finished this lesson?

Introduction to SQL – All Lessons