SQLite upper() function
Description
SQLite upper() converts all the characters in a string to uppercase characters.
The upper(X) function returns a copy of input string X in which all lower-case ASCII characters are converted to their upper-case equivalent.
Syntax:
upper(X);
SQLite Version: 3.8.5
Argument:
Name | Description |
---|---|
X | A string whose characters are to be converted to uppercase. |
Pictorial Presentation

Example: SQLite upper() function
The following SQLite statement returns the given string after converting all of its characters in uppercase.
SELECT upper('my test string');
Here is the result.
Sample Output:
upper('my test string') ----------------------- MY TEST STRING
Example of upper() function on column of a table
The following SQLite statement returns the value of the column first_name from employees table after converting it from lower to upper case.
Sample table: employees
SELECT first_name,upper(first_name)
FROM employees
LIMIT 10;
Here is the result. Here we have displayed the result only 10 rows as a sample result.
Sample Output:
first_name upper(first_name) ---------- ----------------- Steven STEVEN Neena NEENA Lex LEX Alexander ALEXANDER Bruce BRUCE David DAVID Valli VALLI Diana DIANA Nancy NANCY Daniel DANIEL
Previous:
typeof()
Next:
Date and Time Functions Introduction
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook