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