To convert or change the value of a field from lowercase to uppercase, the UCASE() function is used.

 

SQL UCASE() Syntax is as follows:

Select UCASE(column_name)

From table_name;

 

Let us consider the below Students table:

roll_no

Name

total_marks

(out of 600)

percentage

grade

1

Ashok

392

65.33

B

2

Chaitali

454

75.67

A

3

Smriti

502

83.60

A

4

Kaushik

337

56.10

C

 

The following SQL statement selects the ‘name’ column from the Students table, and converts the column to uppercase:

 

Example:

SELECT UCASE(name)
From Students;

 

The result will be as follows:

Name

ASHOK

CHAITALI

SMRITI

KAUSHIK