SQL UPPER, UCASE Function

The UPPER function converts the value of a field to uppercase. The UPPER function is used for SQL Server.
Other SQL platforms may use the UCASE function.

Employees Table

employeeID

employeeName

age

1000

John Smith

40

1001

Fred White

27

1002

Jane Scott

53

1003

Samuel Williams

31

In this example, we want to find to see convert the employeeName field to uppercase in the query results.

Syntax

SELECT UPPER(column_name)
FROM Table

Example

SELECT UPPER(employeeName) as [EMPLOYEE NAME]
FROM employees

Results

EMPLOYEE NAME

JOHN SMITH

FRED WHITE

JANE SCOTT

SAMUEL WILLIAMS

The SQL UPPER function is used to convert a given field in a table to uppercase characters.

Please help us spread the word by socializing it today!

Did you find something wrong with the information on this page? Please take a moment to report it to us
so that we can continue to improve the quality of the information on this site. Click here to
report an issue with this page.