The LCWORD2 function converts the letters in a character string to mixed-case by converting the first letter of each word to uppercase and converting every other letter to lowercase. In addition, a double quotation mark or a space indicates that the next letter should be converted to uppercase.
For example, "SMITH" would be changed to "Smith" and "JACK S" would be changed to "Jack S".
LCWORD2(length, string, output)
Is the length, in characters, of the character string or field to be converted, or a field that contains the length.
Is the character string to be converted, or a temporary field that contains the string.
The length must be greater than or equal to length.
LCWORD2 converts the string O'CONNOR’s to mixed-case:
The value returned is O’Connor’s.