SQL Character Case Functions

Character Case Related Functions

SQL Server:

Upper Case

SELECT UPPER(Employee_Name) FROM Employe;

Lower Case

SELECT LOWER(Employee_Name) FROM Employe;

Initial Letter (Proper Case)

There is no proper case function in SQL Server.

Oracle:

Upper Case

SELECT UPPER(Employee_Name) FROM Employe;

Lower Case

SELECT LOWER(Employee_Name) FROM Employe;

Initial Letter (Proper Case)
 

SELECT INITCAP (Employee_Name) FROM Employe;