Neoview SQL Reference Manual (R2.2)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.2 Software

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)

412 SQL Functions and Expressions