LAST_INDEX_OF

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.