Substring functions
The built-in SQL substring functions return substrings from character string arguments, or return positional information for operations on substrings.
Substring Functions (1) (2) |--+-------| CHARINDEX function |-----+-------------------------| | (1) (3) | +-------| INSTR function |---------+ | (4) | +-| LEFT function |----------------+ | (5) | +-| RIGHT function |---------------+ | (6) | +-| SUBSTR function |--------------+ | (7) | +-| SUBSTRB function |-------------+ | (8) | +-| SUBSTRING function |-----------+ | (9) | '-| SUBSTRING_INDEX function |-----'
Notes:
- Informix® extension
- See CHARINDEX function
- See INSTR function
- See LEFT function
- See RIGHT function
- See SUBSTR function
- See SUBSTRB function
- See SUBSTRING function
- See SUBSTRING_INDEX function
Sections that follow describe the syntax and usage of these substring functions.