How to Convert a String to Uppercase in SQL

Problem

You would like to convert a string to uppercase in SQL.

Example

Our database has a table named questionnaire with data in the following columns: id, first_name, last_name, and favorite_car.

Our table stores the make and model of the favorite car for each person who filled out our questionnaire. Notice that the style in which these strings are written is inconsistent.

Solution 1

SELECT UPPER(favorite_car) AS car
FROM questionnaire;

This query returns each car name in uppercase:

Discussion

If you want to display a string in uppercase, use the SQL UPPER() function. This function takes only one argument: the string column that you want to convert to uppercase.