Converts a string value to lowercase characters.

Syntax

LCASE(expression)

LOWER(expression)

Arguments

  • expression: a character expression of one of these types, or an expression that resolves to one of these types:
    • CHAR
    • VARCHAR
    • LONG VARCHAR

Returns

The same data_types as expression.

Additional Information

  • LCASE and LOWER are both supported, perform the same function, and can be used interchangeably.

Examples

SELECT firstName, LOWER(firstName) AS firstNameLower FROM MYSQL.inventory.cust;

VALUES LOWER('John Smith');
-- Returns john smith