LCASE

The LCASE() function 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:

Was this article helpful?