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