Previous Next JavaScript must be enabled to correctly display this content

## index_of function

The `index_of` function determines the position of the first character of the search string at its first occurrence if any.

    returnvalue index_of(source, search_string [, start_position])

    source ::= any*
    search_string ::= any*
    start_position ::= integer*
    returnvalue ::= integer

Various return values:

- Returns the position of the first character of the search string at its first occurrence. The position is relative to the start position of the string (which is zero).
- Returns -1 if `search_string` is not present in the source.
- Returns 0 for any value of source if the `search_string` is of length 0.
- Returns NULL if any argument is NULL.
- Returns NULL if any argument is an empty sequence or a sequence with more than one item.
- Returns error if `start_position` argument is not an integer.

Example 1: Determine at which position "-" is found in the estimated arrival time of the first leg for the passenger with ticket number 1762320569757.

    SELECT index_of(bag.baginfo.flightLegs[0].estimatedArrival,"-")
    FROM BaggageInfo bag
    WHERE ticketNo=1762320569757

Output:

    {"Column_1":4}

Example 2: Determine at which position "/" is found in the routing of the first leg for passenger with ticket number 1762320569757. This will help you determine how many characters are there for the source point for the passenger with ticket number 1762320569757.

    SELECT index_of(bag.baginfo.routing,"/")
    FROM BaggageInfo bag
    WHERE ticketNo=1762320569757

Output:

    "Column_1":3}