PROPER()

Class

String Data

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(), SUBSTR(), TRIM(), 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

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer