UPCASE Function

Converts all letters in an argument to uppercase.

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

Syntax

Syntax

UPCASE(expression)

Arguments

expression

specifies any valid expression that evaluates to a character string.

Data type	CHAR, NCHAR
See	<sql-expression>
See	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

UPCASE Function

Syntax

Arguments

expression

Details

Comparisons

Example

See Also