Difference between revisions of "PROPER()"

From Recital Documentation Wiki
Jump to: navigation, search
Line 12: Line 12:
  
 
==See Also==
 
==See Also==
[[ISUPPER()]], [[ISLOWER()]], [[LEN()]], [[LOWER()]], [[STREXTRACT()]], [[SUBSTR()]], [[TRIM()]], [[UPPER()]]  
+
[[ISUPPER()]], [[ISLOWER()]], [[LEN()]], [[LOWER()]], [[STREXTRACT()]], [[STRTOLOWER()]], [[STRTOUPPER()]], [[SUBSTR()]], [[TRIM()]], [[UCFIRST()]], [[UPPER()]]  
  
  
Line 27: Line 27:
  
 
==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]]
 
[[Category:String Data Functions]]
 
[[Category:String Data Functions]]

Revision as of 16:15, 14 October 2009

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