Reference Guide > TDV SQL Script > SQL Script Statement Reference > FIND_INDEX
 
FIND_INDEX
Returns the index of the first object in an array. Return zero if nothing is found. If the first item in the array matches the first argument, then 1 is returned.
Syntax
<array>.find_index{<varList>}
Example
PROCEDURE ss1(out i int)
BEGIN
declare v vector(int) default vector [1,2,3,4];
set i = find_index(-5, v);
END