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.
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 doesn't utilize the index.