UCASE() Function in sql server

Introduction:

The UCASE() function converts the value of a field to uppercase.

 

Syntax:

SELECT UCASE(column_name) FROM table_name;

Example:

SELECT UCASE(CustomerName) AS Customer, City
FROM Customers;