Substring functions

The built-in SQL substring functions return substrings from character string arguments, or return positional information for operations on substrings.

Substring Functions

(explicit id sbfu001) sbfu001 (explicit id sbfu002) sbfu002 (explicit id sbfu003) sbfu003 (explicit id sbfu004) sbfu004 (explicit id sbfu010) sbfu010 (explicit id sbfu005) sbfu005 (explicit id sbfu007) sbfu007 (explicit id sbfu008) sbfu008 (explicit id sbfu009) sbfu009
{ [] <CHARINDEX function> [] | [] <INSTR function>[] | <LEFT function>[] | <RIGHT function>[] | <SUBSTR function>[] | <SUBSTRB function>[] | <SUBSTRING function>[] | <SUBSTRING_INDEX function>[] }

Sections that follow describe the syntax and usage of these substring functions.

1 Informix® extension
2 See CHARINDEX function
3 See SUBSTRING function
4 See SUBSTR function
5 See SUBSTRB function
6 See INSTR function
7 See LEFT function
8 See RIGHT function
9 See SUBSTRING_INDEX function