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
No comments:
Post a comment