How to use LOWER () function in Sql Server

LOWER () - Converts a input string to lower case

Example: - Below is “EMPLOYEE” table

Id	EmployeeName	Age
1	ALOK KUMAR SINGH	30
2	TOMAS PAUL	45
3	CRISTOMFER DEE	85
4	NIEL MACENGI	55

Applying UPPER function on “Employee” table and getting below result.

SELECT Id, LOWER(Name) as EmployeeName, Age FROM Employee

Id	Name	Age
1	alok kumar singh	30
2	tomaspPaul	45
3	cristomfer dee	85
4	niel macengi	55

For more Sql scalar function Click here