Learn From - Interactive SQL


Next Chapter »

SQL UPPER() Function


UPPER() Function converts the values of the specified text column to upper case.

SQL UPPER() Syntax


SELECT UPPER(column_name)
FROM table_name

Below is shown the "Authors" table:

FirstName LastName Address City
White Michael 22 Cleveland Av. #24 Berkeley
Hunter Sheryl NULL Salt Lake City
Smith Charlene NULL San Francisco
Jhonson Fernandis 2286 Cram Pl. #81 NULL
Robert Paul 1976 Arlington Pl. NULL

SQL UPPER() Example


Text Editor below has the SQL Query, click the "View Result" button, to see the result.

To convert the value of the FirstName column to upper case.

Select UPPER(FirstName), LastName from Authors;

SQL in Text Editor:








Next Chapter »