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.