UPPER LOWER INITCAP in SQL

For Complete YouTube Video: Click Here

In this class, we will understand UPPER LOWER INITCAP.

We have already discussed the concepts of CONCAT.

UPPER LOWER INITCAP in SQL

LOWER: Converts every letter in the string to lower case.

UPPER: Converts every letter in the ‘string’ to upper case.

INITCAP: Initial Capital. Capitalizes the first letter of the word or a series of ‘words.’

To understand this we will consider the table given below.

Consider the query with UPPER LOWER and INITCAP as shown below.

SELECT UPPER(name), LOWER(name), INITCAP(name) FROM students;

The output of the query is as shown below.