UPPER

Change the text to uppercase.

SELECT UPPER(‘SQL Tutorial is FUN!’);

Definition and Usage

The UPPER() function converts a string to uppercase characters.

Note: Consider using the LOWER() function for converting text to lowercase.

UPPER(text)

Parameter	Description
text	Required. The string that will be converted

Works in:

Available in SQL Server from 2008 onward, as well as in Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse.

Transform the text in the “CustomerName” field to uppercase.

SELECT UPPER(CustomerName) AS UppercaseCustomerName
FROM Customers;