PROPER()

From Lianjapedia
Revision as of 06:42, 4 February 2013 by Helen.george (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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