TO_PROPER
Description
TO_PROPER
is a row function that returns a Text
value with
the first letter of each word capitalized.Syntax
TO_PROPER
(string_expression
)Return Value
Returns one value per row of type
Text
.Input Parameters
- string_expression
- Required. The name of a field or expression of typeText(or a literal string).
Examples
TO_PROPER("123 Alameda de las Pulgas, San Mateo
CA")
Returns
123 Alameda De Las Pulgas, San Mateo Ca