# LCASE

Converts the given string to lower case.

## Syntax

```sql
LCASE (str)
LOWER (str)

```

## Arguments

* str: any string or binary object

## Return Type

String

## Examples

```sql
SELECT LCASE('OLÉ'), LOWER('OLÉ');

```

```output

+---------------+--------------+
| LCASE('OLÉ')  | LOWER('OLÉ') |
+---------------+--------------+
| olé           | olé          |
+---------------+--------------+

```

## Related Topics

* [UCASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/ucase.md)

***

Modified at: February 27, 2023

Source: [/db/v9.1/reference/sql-reference/string-functions/lcase/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/lcase/)

(An index of the documentation is available at /llms.txt)
