{"id":842,"date":"2019-06-10T17:41:50","date_gmt":"2019-06-11T01:41:50","guid":{"rendered":"https:\/\/db2tutorial.com\/?page_id=842"},"modified":"2020-04-11T06:57:57","modified_gmt":"2020-04-11T14:57:57","slug":"db2-upper","status":"publish","type":"page","link":"https:\/\/www.db2tutorial.com\/db2-string-functions\/db2-upper\/","title":{"rendered":"Db2 UPPER"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the Db2 UPPER()<\/code> function to convert all characters of a string to uppercase.<\/p>\n\n\n\n

DB2 UPPER() function overview<\/h2>\n\n\n\n

The UPPER()<\/code> function accepts a string and returns a new string in which all characters in the original string are converted to uppercase.<\/p>\n\n\n\n

Here is the syntax of the UPPER()<\/code> function<\/p>\n\n\n

UPPER(expression)\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, the expression<\/code> must evaluate to a character string or a value that can be implicitly converted to a character string.<\/p>\n\n\n\n
The UPPER()<\/code> function is useful for case-insensitive searches.<\/p>\n\n\n\n
Db2 UPPER() function examples<\/h3>\n\n\n\n
Let’s take some examples of using the UPPER()<\/code> function.<\/p>\n\n\n\n
1) Using Db2 UPPER() to convert a literal string to uppercase.<\/h3>\n\n\n\n
This example uses the UPPER()<\/code> function to convert the string 'Db2 upper'<\/code> to uppercase:<\/p>\n\n\n
SELECT<\/span>\n    UPPER<\/span>('Db2 upper'<\/span>) result<\/span>\nFROM<\/span>\n    sysibm.sysdummy1;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Here is the result set:<\/p>\n\n\n
RESULT    \n--------- <\/span>\nDB2 UPPER \n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
2) Using Db2 UPPER() to perform case insensitive searches<\/h3>\n\n\n\n
See the following authors<\/code> table from the sample database<\/a>:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
The following example uses the UPPER()<\/code> function to search for authors whose last name are Anderson<\/code>:<\/p>\n\n\n
SELECT<\/span>\n    author_id,\n    first_name,\n    last_name\nFROM<\/span>\n    authors<\/span>\nWHERE<\/span> \n    UPPER<\/span>(last_name) = 'ANDERSON'<\/span>;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Here is the output:<\/p>\n\n\n\n
\"Db2<\/figure>\n\n\n\n
To speed up this query, you should consider creating an expression-based index<\/a> for the last_name<\/code> column:<\/p>\n\n\n
CREATE<\/span> INDEX<\/span> ix_ulastname\nON<\/span> authors<\/span>(UPPER<\/span>(last_name));\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this tutorial, you have learned how to use the Db2 UPPER()<\/code> function to convert all characters of a string to uppercase.<\/p>\n
\n\t
\n\t\t
Was this tutorial helpful ?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t