WEB DEVELOPER SITE
HTMLCSSJAVASCRIPTSQLPHPBOOTSTRAPJQUERYANGULARXML
 

SQL UCASE() Function


The UCASE() Function

The UCASE() work changes over the estimation of a field to uppercase.

SQL UCASE() Syntax

SELECT UCASE(column_name) FROM table_name;

Syntax for SQL Server

SELECT UPPER(column_name) FROM table_name;

Demo Database

In this instructional exercise we will utilize the outstanding Northwind test database.

Below is a determination from the "Clients" table:

CustomerID CustomerName Phone City
1

Kenneth H. Stark 360-307-2991 WA
2 Michael C. Ochoa 847-655-9036 IL
3 Dennis A. Shaw 320-323-5667 MN
4

Dennis R. Miller 256-314-2123 AL

SQL UCASE() Example

The following SQL proclamation chooses the "CustomerName" and "City" sections from the "Clients" table, and changes over the "CustomerName" segment to uppercase:

Example

SELECT UCASE(CustomerName) AS Customer, City
FROM Customers;