SQL UCASE() | UPPER() Function

SQL UCASE() | UPPER() Syntax

For MS Access / ORACLE / MY SQL

//  Convert a input string or text expression to uppercase
SELECT UCASE(string or text);
//  Convert a specific table column value to uppercase
SELECT UCASE(column_name1) FROM table_name;

For SQL SERVER / MYSQL

//  Convert a input string or text expression to uppercase
SELECT UPPER(string or text);
//  Convert a specific table column value to uppercase
SELECT UPPER(column_name1) FROM table_name;

SQL UCASE() | UPPER() Example - Using Expression Or Formula

The following SQL SELECT statement will convert of a given input string to uppercase:

For MS Access / ORACLE / MY SQL

SELECT UCASE('WWW.SimmanChith.COM');

For SQL SERVER / MYSQL

SELECT UPPER('WWW.SimmanChith.COM');

The result of above query is:

Sample Database Table - Employee

SQL UCASE() | UPPER() Example

The following SQL statement selects the "ID" and "Dept" fields from the "Employee" table, and converts the "Dept" column to uppercase:

For MS Access / ORACLE / MY SQL

SELECT ID, 
UCASE(Dept) As 'Dept Column In Upper Case' 
FROM Employee;

For SQL SERVER / MYSQL

SELECT ID, 
UPPER(Dept) As 'Dept Column In Upper Case' 
FROM Employee;

The result of above query is: