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 |-------------------------+
| (4) (13) |
+-------| Case-Conversion Functions |------+
| (14) |
'-| Substring Functions |------------------'
Notes:
- See CONCAT Function
- See ASCII Function
- See TRIM Function
- Informix® extension
- See LTRIM Function
- See RTRIM Function
- See SPACE function
- See REVERSE function
- See REPLACE Function
- See LPAD Function
- See RPAD Function
- See CHR Function
- See Case-Conversion Functions
- See Substring functions
Sections that follow describe each of the built-in
string manipulation functions.