The **`LCASE()`** function converts a string sent as a parameter to lowercase. 

Figure 1 shows a visual representation of the `LCASE()` function.

>This method has the same functionality as the `LOWER()` method.

# Syntax
```sql
LCASE(string)
```
# Parameter
The `LCASE()` function takes in a string that needs to be converted to lowercase as a parameter.

# Return value
The `LCASE()` function returns the lowercase version of a string sent as a parameter.

> If a number is sent as a parameter, `LCASE()` returns the number unchanged.

# Example





-- string
SELECT LCASE('HELLO');

-- number
SELECT LCASE(123);

What is LCASE() in SQL?

Converts a string to lowercase, like the LOWER() method, returning unchanged if given a number.