Latest Post

Saturday, 1 October 2016

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

Government Jobs