Previous Topic

Next Topic

Book Contents

Book Index

Examples

Table 200 SUBSTR Function Examples

Function

Returns value:

SUBSTR(2,3,'ABCDEFG')

'BCD'

SUBSTR(1,4,'RULE DEFINITION')

'RULE'

SUBSTR(11,5,'EMPLOYEE: JONES')

'JONES'

SUBSTR(10,1,'TOTALS: $15000')

'1'

SUBSTR(1,9,DB_EMP)

where DB_EMP = 'BARBARA GORDON'

'BARBARA G'

Parent Topic

SUBSTR: Functions