This is an old revision of the document!
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.
$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