Returns a string with the first character of each word set to uppercase and the remaining characters set to lowercase.

Syntax

PROPER(string)

Parameters

string

Character. The value to convert to proper case.

Output

Character.

Remarks

This function converts the first character in the string parameter, and any subsequent character preceded by a blank, to uppercase. Subsequent characters preceded by a hyphen, an apostrophe, an ampersand (&), and several other punctuation marks and special characters are also converted to uppercase. All other alphabetic characters are converted to lowercase.

The most common use for this function is to convert names stored as all uppercase or all lowercase in source data into proper case format, so the name is displayed correctly in a form letter or report.

Examples