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:

derive type:single value:LOWER(MyName)

Output: All of the string values in the MyName column value are written to the new column in lowercase. 

String literal example:

derive type:single value:LOWER('Hello, World')

Output: The string hello, world is written to the new column.

derive type:single value:LOWER(column_string)

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