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

Name Type Description
string character The value to convert to proper case.

Output

Character.

Examples

Basic examples

Returns "John Doe":

PROPER("JOHN DOE")

Returns "John Doe":

PROPER("john doe")

Returns "1550 Alberni St.":

PROPER("1550 ALBERNI st.")

Returns "Bill O'Hara":

PROPER("BILL O'HARA")

Returns all the values in the Company_Name field converted to proper case:

PROPER(Company_Name)

Remarks

How it works

The PROPER( ) function converts the first character in string, 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.

When to use PROPER( )

The most common use for PROPER( ) 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.

ACL Scripting Guide 14.1