LOWER function converts a string expression to lower case.
Syntax:
LOWER(expression);
Return Data Type:
STRING
Example:
Convert a string to lower case:
LOWER('ABC'); --- abc
Compatibility: Oracle, Microsoft SQL Server, IBM DB2, Teradata, PostgreSQL, MySQL and Netezza
Version: PL/HQL 0.03