... Prev . Next . ... MATCH(seek,vector[,type]) . MATCH function finds the row index of @seek in @vector and returns it. If the area is longer than it is wide then the sense of the search is rotated. ... If @type = 1, finds largest value <= @seek. If @type = 0, finds first value == @seek. If @type = -1, finds smallest value >= @seek. For type 0, the data can be in any order. ... And in this case, MATCH uses a binary search to locate the index.) ...