Watch the 7.3 Webinar On-Demand

This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

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É');
+---------------+
| LCASE('OLÉ')  |
+---------------+
| olé           |
+---------------+

UCASE

Was this Article Helpful?

Questions?

Ask the Community, find solutions in the Troubleshooting Overview, get Self-Paced Training or learn more about our Support Plans.