Skip to main content

LOWER

Returns the string str with all characters changed to lowercase.

Syntax​

LOWER(<str>);

Arguments​

ArgumentsDescription
<str>The string to be lowercase

Return Type​

VARCHAR

Examples​

SELECT LOWER('Hello, World!')
+------------------------+
| lower('Hello, World!') |
+------------------------+
| hello, world!          |
+------------------------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today