SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
9-170
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)