Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
APPLIES TO: 
NoSQL
Returns the starting position of the last occurrence of the second string expression within the first specified string expression, or -1 if the string isn't found.
Syntax
LASTINDEXOF(<string_expr1>, <string_expr2> [, <numeric_expr>])
Arguments
| Description | |
|---|---|
string_expr1 |
A string expression to be searched. |
string_expr2 |
A string expression to search for. |
numeric_expr (Optional) |
Optional numeric expression that sets the position the search starts. The search proceeds from position toward the beginning of this instance. The first position in string_expr1 is 0. |
Return types
Returns a numeric expression.
Examples
The following example shows the results of using this function to find the last occurrence of substrings.
SELECT VALUE {
"case1": LASTINDEXOF("abcdeabc", "abc"),
"case2": LASTINDEXOF("abcdeabc", "abc", 6),
"case3": LASTINDEXOF("abcdeabc", "abc", 7),
"case4": LASTINDEXOF("abcdeabc", "fg")
}
[
{
"case1": 5,
"case2": 0,
"case3": 5,
"case4": -1
}
]
Remarks
- This system function will not utilize the index.