WordCap

Description

Sets the first letter of each word in a string to a capital letter and all other letters to lowercase (for example, ROBERT E. LEE would be Robert E. Lee).

Syntax

WordCap ( string )

Argument	Description
string	A string or expression that evaluates to a string that you want to display with initial capital letters (for example, Monday Morning)

Returns

String. Returns string with the first letter of each word set to uppercase and the remaining letters lowercase if it succeeds, and null if an error occurs.

Examples

Example 1

This expression returns Boston, Massachusetts:

WordCap("boston, MASSACHUSETTS")

Example 2

This expression concatenates the characters in the emp_fname and emp_lname columns and makes the first letter of each word uppercase:

WordCap(emp_fname + " " + emp_lname)