SQLite upper() Function

The SQLite upper() function converts the given string to uppercase and returns it.

Syntax

This is the syntax of the SQLite upper() function:

upper(str)

Parameters

str

Required. A string that needs to be converted to uppercase.

Return value

The SQLite upper() function returns the uppercase form of the specified string.

If the parameter is NULL, the function will return NULL.

Examples

This example shows how to convert a string to uppercase using the upper() function.

SELECT upper('Hello World');

upper('Hello World')
--------------------
HELLO WORLD