substring function
The
substring
function extracts a string from a given string
according to a given numeric starting position and a given numeric substring
length.
returnvalue substring (source, position [, substring_length] )
source ::= any*
position ::= integer*
substring_length ::= integer*
returnvalue ::= string
Example: Fetch the first three characters from the routing details of
a passenger with ticket number
1762376407826.
SELECT substring(bag.baginfo.routing,0,3) AS Source
FROM baggageInfo bag
WHERE ticketNo=1762376407826
Output:
{"Source":"JFK"}