SQL Reference

LCASE(string)

string: This parameter represents the text string that you want to convert to lowercase. The value provided should be a valid string expression.

Example

SELECT LCASE('Hello World!');

Output

'hello world!'

Explanation

In the above example, the LCASE() function converts the text ‘Hello World!’ to lower case. The result is ‘hello world!’. The LCASE() function in MySQL is used to convert all the characters in a string to lower case.

LCASE( string )

string: This is the input parameter to the LCASE function. It represents the text string that you want to convert to lowercase. The string can be a column name that stores the text data, a literal string, or a variable holding the text data. It must be of a data type that is implicitly convertible to varchar. In case of NULL input, the function returns NULL.

Example

SELECT LCASE('SQL SERVER EXAMPLE') AS LowerCase;

Output

lowercase
---------------------
sql server example

Explanation

In the provided example, the LCASE function is used to convert all the uppercase letters in a string to lowercase. The string here is ‘SQL SERVER EXAMPLE’. The output of this SQL statement is ‘sql server example’.

LCASE(string)

string: The string parameter represents the text which will undergo conversion. All uppercase characters in this provided string will be converted to their lowercase counterparts.

Example

SELECT LCASE('HELLO WORLD') FROM dual;

Output

'hello world'

Explanation

In Oracle, the LCASE() function converts all letters in the specified string to lowercase. In the provided example, the string ‘HELLO WORLD’ is converted to ‘hello world’.