<< Click to Display Table of Contents >> PROPER (convert text to upper/lower case)

Syntax:

PROPER(Text)

Description:

Converts all characters in a text string as follows: The first letter of each word is converted to an uppercase letter, all other letters are converted to lowercase letters.

Example:

PROPER("good morning") returns Good Morning

PROPER("Good Morning") returns Good Morning

PROPER("GoOd MoRnInG") returns Good Morning

See also:

UPPER, LOWER