Differences

This shows you the differences between two versions of the page.

Link to this comparison view

dev:sql:functions:proper [2010/07/09 20:09]
els
dev:sql:functions:proper [2016/06/28 22:38]
Line 1: Line 1:
-{{page>:​top_add&​nofooter&​noeditbtn}} 
-{{page>:​sql_bar&​nofooter&​noeditbtn}} 
-====== Omnidex SQL Function: $PROPER ====== 
-===== Description ===== 
-Converts a string to proper case, meaning that the first character of each word in made upper case and the remaining characters are lower case. 
  
-This function returns the same datatype as the passed parameter. 
- 
-===== Syntax ===== 
- 
-  $PROPER( character_expression ) 
- 
-== character_expression ==  
- 
-Required. ​ Any expression that returns a character-class datatype. ​ Examples of expressions are columns, concatenations of columns, literal strings and functions that return a character datatype.  ​ 
- 
- 
-===== Examples ===== 
-==== Example: Column ==== 
-<​code>​ 
-> select $proper(name) nme from individuals;​ 
- 
-NME 
--------------------------------------------------- 
-Ms. Mary Lewis 
-Mrs. Alice R Tolliver 
-Mr. Sidney K Tolliver 
-Mrs. Jennifer J Hopkins 
-Mr. Charlie Hopkins 
-Ms. Kimberly Blue 
-Kathleen Tucker 
-</​code>​ 
-====== Additional Resources ====== 
- 
-See also: 
-{{page>​dev:​sql:​functions:​see_also_string&​nofooter&​noeditbtn&​noheader}} 
- 
- 
-  
-{{page>:​bottom_add&​nofooter&​noeditbtn}} 
 
Back to top
dev/sql/functions/proper.txt ยท Last modified: 2016/06/28 22:38 (external edit)