SQLite Upper() Function

Here we will learn Upper() function in SQLite and how to use SQLite Upper() function to convert given string characters to uppercase with examples.

SQLite Upper() Function

In SQLite upper() function is used to convert given text to uppercase or specified string characters to uppercase.

In case if the given string contains other than letters means those characters won’t affect with this upper() function.

Syntax of SQLite Upper() Function

Following is the syntax of SQLite upper() function to convert given string characters to uppercase.

In above SQLite upper() function syntax, we defined few parameters those are

string – Its source string which is used to convert string characters to uppercase.

Now we will see how to use SQLite upper() function to convert specified string characters to uppercase with examples.

SQLite Upper() Function Examples

The following are the simple examples of SQLite Upper() function to convert specified string characters to uppercase.

SQLite Upper Function with Table Column

Now we will see how to use SQLite Upper() function with tables to convert columns data to uppercase. Consider we have a table called “test” with the following records.

Now we will update the test table column i value with Upper() function to convert values to Upper case like as shown following.

Now we will check the records of test table using following SELECT statement.

This is how we can use SQLite upper() function to convert required string characters to uppercase based on our requirements.