This section introduces you to the Db2 string functions that help you manipulate character string data effectively.
| Function | Description |
|---|---|
| CONCAT | Concatenate two strings into a single string. |
| INITCAP | Convert a string to proper case or title case format. |
| INSERT | Insert a substring into a string starting from a position and also deletes a substring specified by a length from the string. |
| INSTR | Return the position of the nth occurrence of a substring within a string. |
| LEFT | Extract a substring that consists of the number of leftmost characters from a string. |
| LOCATE | Find the position of the first occurrence of a string within another string |
| LOWER | Convert a string to lowercase |
| LPAD | Return a string that is padded on the left with the specified character, or with blanks. |
| LTRIM | Remove specified string from the beginning of a string. |
| REPEAT | Repeat a string a number of times |
| REPLACE | Replace all occurrence of a substring in a string with a new substring. |
| RIGHT | Extract a substring that consists of the number of rightmost characters from a string. |
| RPAD | Return a string that is padded on the right with the specified character, string, or with blanks. |
| RTRIM | Remove specified characters from the end of a string. |
| SPACE | Return a character string that consists of a specified number of blanks. |
| SUBSTRING | Extract a substring with a specified length from a string. |
| TRANSLATE | Return a string in which one or more characters in a string are converted to other characters. |
| TRIM | Remove blanks or another specified character from the end, the beginning, or both ends of a string expression. |
| UPPER | Convert all characters of a string to uppercase. |
Was this tutorial helpful ?
