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) |
Return value
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
This expression returns Boston, Massachusetts:
WordCap("boston, MASSACHUSETTS")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)
