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: