SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-146
Examples of SUBSTRING
•
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
•
Extract 'Ro':
SUBSTRING('Robert John Smith' FROM 0 FOR 3)
•
Extract 'John':
SUBSTRING ('Robert John Smith' FROM 8 FOR 4)
•
Extract 'John Smith':
SUBSTRING ('Robert John Smith' FROM 8)
•
Extract 'Robert John Smith':
SUBSTRING ('Robert John Smith' FROM 1 FOR 17)
•
Extract 'John Smith':
SUBSTRING ('Robert John Smith' FROM 8 FOR 15)
•
Extract 'Ro':
SUBSTRING ('Robert John Smith' FROM -2 FOR 5)
•
Extract an empty string '':
SUBSTRING ('Robert John Smith' FROM 8 FOR 0)