Capitalize words | TEXT_CAPITALIZE_WORDS

Syntax

TEXT_CAPITALIZE_WORDS( [value] )

Parameters

value
The TEXT value for which the words will be capitalized. If it is not a TEXT value, it will be converted to one with the STRING operation.

Return Value

A new TEXT with all the characters in VALUE converted to upper case.

Description

Convert the first letter of each word in a TEXT to upper case.

Examples

TEXT_CAPITALIZE_WORDS("four score and seven years") # returns "Four Score And Seven Years"

TEXT_CAPITALIZE_WORDS("") # returns ""

TEXT_CAPITALIZE_WORDS(null) # returns ""

TEXT_CAPITALIZE_WORDS(1234) # returns "1234"