Skip to main content

​
Description

Returns the position of the last occurrence of a search string in a string field, when searching backward from the end of the string.

​
Syntax

LAST_INDEX_OF(string, search_string)

​
Arguments

string - string expression to search in search_string - string expression to search for

​
Examples

LAST_INDEX_OF('Ventura Beach,93009,CA',',') returns 19

​
Return value datatype

Int

​
Impact of null value

If any (or all) inputs are null, returns null.
Last modified on April 15, 2026