toLower
toLower formats a string in all lowercase. toLower skips rows containing null values.
Syntax
Copy
toLower(expression)
Arguments
expression
The expression must be a string. It can be the name of a field that uses the string data type, a literal value like '12 Main Street', or a call to another function that outputs a string.
Return type
String
Example
The following example converts a string value into lowercase.
Copy
toLower('Seattle Store #14')
The following value is returned.
Copy
seattle store #14