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

Syntax:

PROPER(Text)

Description:

This converts all characters in a text string as follows: The first letter of each word is converted into an uppercase letter, all other letters are converted into 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