Converts all characters in a string to lowercase.
CHAR
NCHAR
LONG VARCHAR
VARCHAR
NVARCHAR
The result data type is a LONG VARCHAR. If you use LOWER in a SELECT INTO statement, you must have an Unstructured Data Analytics Option license or use CAST and set LOWER to the correct data type and size.