UPCASE Function

Converts all letters in an argument to uppercase.

Category: Character
Alias: UPPER
Returned data type: VARCHAR, NVARCHAR

Syntax

UPCASE(expression)

Arguments

expression

specifies any valid expression that evaluates to a character string.

Data type CHAR, NCHAR
See <sql-expression>
FedSQL Expressions

Details

The UPCASE function copies a character expression, converts all lowercase letters to uppercase letters, and returns the altered value as a result.

Comparisons

The LOWCASE function converts all letters in an argument to lowercase letters. The UPCASE function converts all letters in an argument to uppercase letters.

Example

The following statement illustrates the UPCASE function:
Statements
Results
select upcase('John B. Smith');
JOHN B. SMITH

See Also

Functions:
Last updated: February 23, 2017