Explain LOWER Function in SQL?

Programming Language
#1

LOWER() :

This function in SQL Server helps to convert all the letters of the given string to lowercase. If the given string contains characters other than alphabets, then they will remain unchanged by this function.

Syntax :

LOWER( str )

Parameters : str – The string which will be converted to lowercase

Result : This function returns the lowercase string.

Example: Using LOWER() function with Uppercase string.

SELECT LOWER('WAKE UP AND TAKE UP') As New;

Output :

New

wake up and take up