The UCASE() Function
The UCASE() function converts the value of a field to uppercase.
SQL UCASE() Syntax
SELECT UCASE(column_name) FROM table_name;
Syntax for SQL Server
SELECT UPPER(column_name) FROM table_name;
Example
SELECT UCASE(CustomerName) AS Customer, City
FROM Customers;
FROM Customers;