{"id":653,"date":"2019-06-05T07:01:13","date_gmt":"2019-06-05T15:01:13","guid":{"rendered":"https:\/\/db2tutorial.com\/?page_id=653"},"modified":"2020-04-11T06:58:34","modified_gmt":"2020-04-11T14:58:34","slug":"db2-string-functions","status":"publish","type":"page","link":"https:\/\/www.db2tutorial.com\/db2-string-functions\/","title":{"rendered":"Db2 String Functions"},"content":{"rendered":"\n

This section introduces you to the Db2 string functions that help you manipulate character string data effectively.<\/p>\n\n\n\n

<\/p>\n\n\n\n

Function<\/th>Description<\/th><\/tr><\/thead>
CONCAT<\/a><\/td>Concatenate two strings into a single string.<\/td><\/tr>
INITCAP<\/a><\/td>Convert a string to proper case or title case format.<\/td><\/tr>
INSERT<\/td>Insert a substring into a string starting from a position and also deletes a substring specified by a length from the string.<\/td><\/tr>
INSTR<\/a><\/td>Return the position of the nth occurrence of a substring within a string.<\/td><\/tr>
LEFT<\/a><\/td>Extract a substring that consists of the number of leftmost characters from a string.<\/td><\/tr>
LOCATE<\/a><\/td>Find the position of the first occurrence of a string within another string<\/td><\/tr>
LOWER<\/a><\/td>Convert a string to lowercase<\/td><\/tr>
LPAD<\/td>Return a string that is padded on the left with the specified character, or with blanks.<\/td><\/tr>
LTRIM<\/a><\/td>Remove specified string from the beginning of a string.<\/td><\/tr>
REPEAT<\/td>Repeat a string a number of times<\/td><\/tr>
REPLACE<\/a><\/td>Replace all occurrence of a substring in a string with a new substring.<\/td><\/tr>
RIGHT<\/a><\/td>Extract a substring that consists of the number of rightmost characters from a string.<\/td><\/tr>
RPAD<\/td>Return a string that is padded on the right with the specified character, string, or with blanks.<\/td><\/tr>
RTRIM<\/a><\/td>Remove specified characters from the end of a string.<\/td><\/tr>
SPACE<\/td>Return a character string that consists of a specified number of blanks.<\/td><\/tr>
SUBSTRING<\/a><\/td>Extract a substring with a specified length from a string.<\/td><\/tr>
TRANSLATE<\/td>Return a string in which one or more characters in a string are converted to other characters.<\/td><\/tr>
TRIM<\/a><\/td>Remove blanks or another specified character from the end, the beginning, or both ends of a string expression.<\/td><\/tr>
UPPER<\/a><\/td>Convert all characters of a string to uppercase.<\/td><\/tr><\/tbody><\/table><\/figure>\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