Neoview SQL Reference Manual (R2.4 SP2)

• If the start position is greater than the length of the character expression, an empty string
('') is returned.
• The resulting substring is always of type VARCHAR. If the source character string is an
upshifted CHAR or VARCHAR string, the result is an upshifted VARCHAR type.
Examples of SUBSTRING/SUBSTR
• Extract 'Ro':
SUBSTRING('Robert John Smith' FROM 0 FOR 3)
SUBSTR('Robert John Smith' FROM 0 FOR 3)
• Extract 'John':
SUBSTRING ('Robert John Smith' FROM 8 FOR 4)
SUBSTR ('Robert John Smith' FROM 8 FOR 4)
• Extract 'John Smith':
SUBSTRING ('Robert John Smith' FROM 8)
SUBSTR ('Robert John Smith' FROM 8)
• Extract 'Robert John Smith':
SUBSTRING ('Robert John Smith' FROM 1 FOR 17)
SUBSTR ('Robert John Smith' FROM 1 FOR 17)
• Extract 'John Smith':
SUBSTRING ('Robert John Smith' FROM 8 FOR 15)
SUBSTR ('Robert John Smith' FROM 8 FOR 15)
• Extract 'Ro':
SUBSTRING ('Robert John Smith' FROM -2 FOR 5)
SUBSTR ('Robert John Smith' FROM -2 FOR 5)
• Extract an empty string '':
SUBSTRING ('Robert John Smith' FROM 8 FOR 0)
SUBSTR ('Robert John Smith' FROM 8 FOR 0)
460 SQL Functions and Expressions