PROPER(S)

 

Description

This function returns the string S with the first letter of each word capitalized.

 

Parameters

 

S

A string value.

 

Examples

 

PROPER("president") = "President"

 

PROPER(P9) = "Chicago"

Where P9 = "CHICAGO".

 

PROPER(E18) = "Chapel Hill"

Where E18 = "chapel hill".