All alphabetical characters in the input value are converted to lowercase in the output value.

Input can be a column reference or a string literal.

Column reference example:


Output: Returns the string value from the MyName column in lowercase. 

String literal example:

lower('Hello, World')

Output: The string hello, world is returned.


ArgumentRequired?Data TypeDescription
column_stringYstringName of the column or string literal to be applied to the function


Name of the column or string constant to be converted.

Required?Data TypeExample Value
YesString literal or column referencemyColumn

Example - uppercase, lowercase, propercase functions