PROPER( ) function

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

Example Return value

PROPER("JOHN DOE")

"John Doe"

PROPER("john doe")

"John Doe"

PROPER("1550 ALBERNI st.")

"1550 Alberni St."

PROPER("BILL O'HARA")

"Bill O'Hara"

PROPER(Company_Name)

All values in the “Company_Name” field converted to proper case

Related reference
LOWER( ) function
UPPER( ) function


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback