Skip to main content

LCASE

Converts the given string to lower case.

Syntax

LCASE (str)
LOWER (str)

Arguments

  • str: any string or binary object

Return Type

String

Examples

SELECT LCASE('OLÉ'), LOWER('OLÉ');
****
+---------------+--------------+
| LCASE('OLÉ')  | LOWER('OLÉ') |
+---------------+--------------+
| olé           | olé          |
+---------------+--------------+