PROPER( )

Topic group Related topics

Converts a character string to proper-noun format and returns the resulting string.

Syntax

PROPER(<expC>)

<expC>

The character string to convert to proper-noun format.

Description

PROPER( ) returns <expC> with the first character in each word capitalized and the remaining letters set to lowercase. PROPER( ) changes the first character of a word only if it is a lowercase alphabetic character.

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 toProperCase( ) method behaves identically to the PROPER( ) function.