SQL Server UPPER() Function

Convert the text to upper-case

Definition and Usage

The UPPER() function converts a string to upper-case.

Note: Also look at the LOWER() function.

UPPER(text)

Parameter	Description
text	Required. The string to convert

Works in:	SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Convert the text in "CustomerName" to upper-case:

SELECT UPPER(CustomerName) AS UppercaseCustomerName
FROM Customers;

Email:

Content: