This shows you the differences between two versions of the page.
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}} |