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.
$PROPER( 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.
> 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
See also: