Single Row Functions

Case-manipulation functions

Lower, Upper and Initcap are the three Case-manipulation/ Case-Conversion Function

Lower:

Converts mixed or uppercase character to lowercase.

Example:

Select Lower (‘SQL Course’);

Output:

sql course

Upper:

Converts mixed or lowercase character to uppercase.

Example:

Select Lower (‘sql course’);

Output:

SQL COURSE

Initcap:

Coverts first letter to of each word to uppercase and remaining letters to lowercase.

Example:

Select Initcap (‘sql course’);

Output:

Sql Course