UPPER( )

Topic group Related topics Example

Converts all lowercase characters in a string to uppercase and returns the resulting string.

Syntax

UPPER(<expC>)

<expC>

The character string you want to convert to uppercase.

Description

UPPER( ) converts the lowercase alphabetic characters in a character expressionor memo field to uppercase. UPPER( ) ignores digits and other characters.

The current language driver defines the character values that are lowercase and uppercase alphabetic. In a U.S. language driver, a lowercase alphabetic character is from a to z, and an uppercase alphabetic character is from A to Z.

Other than the syntactic difference of being a method instead of a function, the toUpperCase( ) method behaves identically to the UPPER( ) function.