Difference between revisions of "PROPER()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
String Data
 
 
 
 
==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
Line 12: Line 8:
  
 
==See Also==
 
==See Also==
[[TRIM()]], [[LEN()]], [[STREXTRACT()]], [[SUBSTR()]], [[UPPER()]], [[LOWER()]], [[ISUPPER()]], [[ISLOWER()]]
+
[[ISUPPER()]], [[ISLOWER()]], [[LEN()]], [[LOWER()]], [[STREXTRACT()]], [[STRTOLOWER()]], [[STRTOUPPER()]], [[SUBSTR()]], [[TRIM()]], [[UCFIRST()]], [[UPPER()]]  
  
  
Line 27: Line 23:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:String Data]]
 +
[[Category:String Data Functions]]

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