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