locate
function
Applies to: Databricks SQL Databricks Runtime
Returns the position of the first occurrence of substr
in str
after position pos
. This function is a synonym for position function.
Arguments
subtr
: A STRING expression.str
: A STRING expression.pos
: An optional INTEGER expression.