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

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.