Converts an input string to propercase. Input can be a column reference or a string literal.

Propercase is strict title case. If the first character of any non-breaking segment of letters in the string is an alphabetical character, it is capitalized. Otherwise, the string is unchanged. See the examples below.

Basic Usage

Column reference example:

derive type:single value:PROPER(MyName)

Output: All of the string values in the MyName column value are written to the new column in Proper Case.