Difference between revisions of "PROPER()"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 12: Line 12:
  
 
==See Also==
 
==See Also==
[[TRIM()]], [[LEN()]], [[STREXTRACT()]], [[SUBSTR()]], [[UPPER()]], [[LOWER()]], [[ISUPPER()]], [[ISLOWER()]]
+
[[ISUPPER()]], [[ISLOWER()]], [[LEN()]], [[LOWER()]], [[STREXTRACT()]], [[SUBSTR()]], [[TRIM()]], [[UPPER()]]  
  
  
Line 30: Line 30:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:String Data]]
 +
[[Category:String Data Functions]]

Revision as of 16:04, 2 June 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(), 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