Overview

The SQLite UPPER() function converts a string into uppercase letters. We can use this function to convert column text values to uppercase.

SQLite UPPER() Function

Syntax

The general syntax of the UPPER() function is as follows:

UPPER(argument)

UPPER(column_name)

Example

Let’s understand the function usage with the help of an example.

SELECT UPPER(ename), salary
FROM emp ;

In the query results, the column ‘ename’ will be in uppercase letters.

—

SQLite Tutorials

SQLite tutorials on this website:

https://www.testingdocs.com/sqlite-database-tutorials/

For more information on SQLite, visit the official website:

https://www.sqlite.org/