UPPER LOWER INITCAP in SQL || Lesson 56 || DBMS || Learning Monkey ||

preview_player
Показать описание
In this class, we will understand UPPER LOWER INITCAP in SQL.

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.'

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

The output of the query is as shown below.

#learningmonkey #dbms #placements #gatecse #gatedbms #campusplacements

Link for playlists:

Рекомендации по теме
Комментарии
Автор

Hi sir i hope you are good .your videos helps alot for freshers .Sir Can you do a series on ServiceNow application Developement

charanch