This shows you the differences between two versions of the page.
— |
lower [2015/09/23 20:27] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== LOWER Function - PL/HQL Reference====== | ||
+ | |||
+ | LOWER function converts a string expression to lower case. | ||
+ | |||
+ | **Syntax**: | ||
+ | |||
+ | <code language="sql"> | ||
+ | LOWER(expression); | ||
+ | </code> | ||
+ | |||
+ | **Return Data Type:** | ||
+ | |||
+ | STRING | ||
+ | |||
+ | **Example:** | ||
+ | |||
+ | Convert a string to lower case: | ||
+ | |||
+ | <code language="sql"> | ||
+ | LOWER('ABC'); | ||
+ | --- | ||
+ | abc | ||
+ | </code> | ||
+ | |||
+ | **Compatibility**: Oracle, Microsoft SQL Server, IBM DB2, Teradata, PostgreSQL, MySQL and Netezza | ||
+ | |||
+ | **Version**: PL/HQL 0.03 | ||