Difference between revisions of "PROPER()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to convert words to lower case with the first character in upper case
 
Function to convert words to lower case with the first character in upper case

Latest revision as of 15:02, 7 December 2009

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


Products

Recital Server, Recital