Upper Query with examples

Print Emp_Name in All Capital letter using UPPER Query

SELECT        UPPER (emp_name) AS EmployeeName

FROM            tbl_emp

Result-

EmployeeName

SURYAGROOPS

SURESH

MAYANK DIXIT

SURYAGROOPS

RAMESH

RAMESH

SHALINI

SUSHIL

Print only First letter in capital

SELECT        UPPER (SUBSTRING (emp_name, 1, 1)) + SUBSTRING (emp_name, 2, 15) AS 

EmployeeName

 FROM            tbl_emp

Result-

EmployeeName

Suryagroops

Suresh

Mayank dixit

Suryagroops

Ramesh

Ramesh

Shalini

Sushil

Print ‘-’ after First letter in capital

SELECT        UPPER (SUBSTRING (emp_name, 1, 1)) + ‘-’ + SUBSTRING (emp_name, 2, 15) AS EmployeeName

FROM            tbl_emp

Result-

EmployeeName

S-uryagroops

S-uresh

M-ayank dixit

S-uryagroops

R-amesh

R-amesh

S-halini

S-ushil

Make Alias

SELECT        emp_name AS 'Employee Name', emp_mobno AS 'Employee Mobile'

FROM            tbl_emp

Or

SELECT ‘Employee Name’ = Emp_Name, ’Employee Name’ = Emp_MobNo

Result-

Employee Name	Employee Mobile
Suryagroops	9532771738
Suresh	9452358456
Mayank dixit	9896564556
Suryagroops	9878522132
Ramesh	8004677781
Ramesh	8785455852