String-Manipulation Functions
String-manipulation functions perform various operations on strings of characters.
The string-manipulation functions are identified in the following
diagram:
String-Manipulation Functions
(1)
|--+-| CONCAT Function |----------------------+-----------------|
| (2) |
+-| ASCII Function |-----------------------+
| (3) |
+-| TRIM Function |------------------------+
| (4) (5) |
+-------| LTRIM Function |-----------------+
| (4) (6) |
+-------| RTRIM Function |-----------------+
| (7) |
+-| SPACE Function |-----------------------+
| (8) |
+-| REVERSE Function |---------------------+
| (4) (9) |
+-------| REPLACE Function |---------------+
| (4) (10) |
+-------| LPAD Function |------------------+
| (4) (11) |
+-------| RPAD Function |------------------+
| (12) |
+-| CHR Function |-------------------------+
| (14) |
+-|SOUNDEX Function |----------------------+
| (15) |
+-------| Case-Conversion Functions |------+
| (16) |
|-| Substring Functions |------------------|
Sections that follow describe each of the built-in string manipulation functions.