{"id":846,"date":"2019-06-10T19:22:58","date_gmt":"2019-06-11T03:22:58","guid":{"rendered":"https:\/\/db2tutorial.com\/?page_id=846"},"modified":"2020-04-11T06:57:56","modified_gmt":"2020-04-11T14:57:56","slug":"db2-lower","status":"publish","type":"page","link":"https:\/\/www.db2tutorial.com\/db2-string-functions\/db2-lower\/","title":{"rendered":"Db2 LOWER"},"content":{"rendered":"\n

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

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

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

The following shows the syntax of the LOWER()<\/code> function:<\/p>\n\n\n

LOWER(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> is a character string expression that evaluates to a string or a value which can be implicitly converted to a string.<\/p>\n\n\n\n
Similar to the UPPER()<\/a><\/code> function, the LOWER()<\/code> function can be useful for case insensitive searches.<\/p>\n\n\n\n
Db2 LOWER() function examples<\/h3>\n\n\n\n
Let’s take some examples of using the LOWER()<\/code> function.<\/p>\n\n\n\n
1) Using Db2 LOWER() to convert a literal string to lowercase<\/h3>\n\n\n\n
The following example uses the LOWER()<\/code> function to convert the string 'Db2 lower'<\/code> to uppercase:<\/p>\n\n\n
SELECT<\/span>\n    LOWER<\/span>('Db2 lower'<\/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 lower \n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
2) Using Db2 LOWER() to perform case insensitive searches<\/h3>\n\n\n\n
See the following publishers<\/code> table in the sample database<\/a>:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
This example uses the LOWER()<\/code> function to find the publisher whose name is apress<\/code>:<\/p>\n\n\n
SELECT<\/span>\n    publisher_id,\n    name<\/span> \nFROM<\/span> publishers\nWHERE<\/span> \n    LOWER<\/span>(name<\/span>) = 'apress'<\/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
PUBLISHER_ID NAME                                                                    \n------------ ------- <\/span>\n14           Apress \n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
CREATE<\/span> INDEX<\/span> ix_uname\nON<\/span> publishers(UPPER<\/span>(name<\/span>));\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 LOWER()<\/code> function to convert all characters of a string to lowercase.<\/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
To improve the speed of the query, you can create an expression-based index<\/a> on the name column of the publishers<\/code> table:<\/p>\n\n\n