SQL UCASE, SQL UPPER

The SQL UCASE, or SQL UPPER function is used to convert a string to upper case. In SQL Server, it uses the UPPER function.

SQL UCASE, SQL UPPER Syntax

SELECT UCASE(string_expression)
FROM table_name

OR in SQL Server:

SELECT UPPER(string_expression)
FROM table_name

SQL UCASE, SQL UPPER Example

Table: Employees

We want to convert Department to upper case:

SELECT EmployeeId, FirstName, LastName, UCASE(Department) AS Department
FROM Employees

The result will look like: