Returns the position of the first occurrence of
str after position
pos and return value are 1-based.
pos is omitted,
substr is searched from the beginning of
pos is less than 1, the result is 0.
This function is a synonym for locate function (Databricks SQL).