SQL - SPLessons

SQL Upper – Lower

Chapter 46

SPLessons 5 Steps, 3 Clicks
5 Steps - 3 Clicks

SQL Upper – Lower

SQL Upper – Lower

shape Description

SQL UPPER converts every letter of a string into upper case. SQL LOWER converts every letter of a string into lower case. And also if the string is attached with some numerical or special symbols, they remain unaffected by these functions.

shape Syntax

The syntax for upper case is as follows:

UPPER(expression);

The syntax for lower case is as follows:

LOWER(expression); 

shape Examples

The execution of uppercase is as follows:

sql>SELECT UPPER('splessons');
The output of above query is
SPLESSONS 

sql>SELECT UPPER('america');
The output of above query is
AMERICA

The execution of lower case is as follows:

sql> SELECT LOWER('ACer123');
The output of above query is
acer123

sql>SELECT LOWER('SYSTEM');
The output of above query is
system

Summary

shape Key Points

  • SQL LOWER – Changes a string into lower case.
  • SQL UPPER  – Changes a string into upper case.