Snippet

Converting Text to Uppercase with UPPER

The UPPER string function processes input text values and transforms all letters into uppercase form. It is frequently used for case-insensitive data formatting or comparisons.

snippet.sql

sql

SELECT UPPER(last_name) FROM employees;

Breakdown

SELECT UPPER(last_name) FROM employees;

Retrieves the 'last_name' column from 'employees', returning all values formatted in capital letters.

Previous snippet Next snippet

More Beginner SQL exercises →

Converting Text to Uppercase with UPPER

Related