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 |