7.1
2013-09-23

PROPER

Syntax

PROPER(Text)

Description

Converts the first letter of each word to an uppercase character, and the rest to lowercase.

Example

PROPER ("PERSONALIZED printing") => Personalized Printing

Parameter description

Text

Any text expression or data field containing a text.

This function allows you to clean up improperly filled out databases or to amend all lowercase or all uppercase information.