Skip to main content

LOWER

Returns the string argument in lower case.

Syntax​

LOWER ( string_expression )

Arguments​

string_expression
A valid string expression.

Return Type​

Returns values of type STRING.

Examples​

Examples in this section use the example blockchain.

The following example returns "DINOSAUR" in lower case.

SELECT LOWER("DINOSAUR") FROM example;

Response:

LOWER(str) [STRING]
dinosaur