Advertisement

Latest Post

Saturday, 1 October 2016

Sql UPPER () - Converts a input string to upper case



UPPER () - Converts a input string to upper case
Example: - Below is “EMPLOYEE” table

Id
Name
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, UPPER(Name) as EmployeeName, Age FROM Employee


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

For more Sql scalar function Click here

Government Jobs