LCASE Function in SQL

The LCASE function converts all characters in a string to lowercase.

Syntax:

LCASE(string)

• string: The input string you want to convert to lowercase.

Example:

SELECT LCASE('Hello World') AS lowercase_text;

Result:

Notes:

• LCASE is a synonym for LOWER() in many databases (like MySQL).

• Use LOWER() if LCASE is not supported.

If you want, I can also show examples with UPPER() or other string functions!