PROPER()

Purpose

Function to convert words to lower case with the first character in upper case

Syntax

PROPER(<expC>)

See Also

ISUPPER(), ISLOWER(), LEN(), LOWER(), STREXTRACT(), STRTOLOWER(), STRTOUPPER(), SUBSTR(), TRIM(), UCFIRST(), UPPER()

Description

The PROPER() function converts the first character of the specified <expC> to upper case and the remaining characters of the word to lower case.

Example

? proper("ACCOUNTS")
Accounts