PROPER

 

Syntax

PROPER(string_value)

Description

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

Example

PROPER ("JoHn AbRAHamS") => John Abrahams

 

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