LCASE

Description

Convert all strings in the parameter to lowercase.

Alias

• LOWER

Syntax

LCASE ( <str> )

Parameters

Parameter	Description
<str>	String to be converted to lowercase

Return Value

Parameter <str> String converted to lowercase

Example

SELECT LCASE("AbC123"),LOWER("AbC123")

+-----------------+-----------------+
| lower('AbC123') | lower('AbC123') |
+-----------------+-----------------+
| abc123          | abc123          |
+-----------------+-----------------+