TO_LOWER
Description
TO_LOWER
is a row function that converts all alphabetic characters in a
Text
value to lower case.Syntax
TO_LOWER
(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
Return the literal input string
123 Main Street
in all lower case letters:TO_LOWER("123 Main Street") returns
123 main
street