Skip to main content
SQL โ€ข LESSON 133

UPPER

How can we convert employee names to uppercase?

Advancedโฑ 3 Minutesโญ 1460 XP
๐Ÿค” THE QUESTION

How can we convert employee names to uppercase?

๐Ÿ’ก WHAT IS IT?

UPPER() converts all characters in a string to uppercase.

๐ŸŽฏ WHAT IS IT USED FOR?

Standardizing country codes, case-insensitive comparison normalization, formal output formatting.

๐Ÿ’ป EXAMPLE
SELECT UPPER(name) AS employee_name
FROM employees;

๐ŸŽฏ Mission Objectives

Practice typing production-grade SQL code for UPPER.

  • โœ“ UPPER() function
  • โœ“ Case standardization
  • โœ“ String transformation
  • โœ“ Text formatting