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é          |
+---------------+--------------+

Last modified: February 27, 2023

Was this article helpful?