SQLite UPPER() Function

SQLite UPPER() Function

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

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/