STRPOS()
is used to return the position from where the substring (the second argument) is matched with the string (the first argument).
string
.
Special cases:
NULL
if there are no input rows or NULL
values.substring
is not found in the string, then the STRPOS()
function will return 0.STRPOS()
functionSTRPOS()
function: