INSTR
The InStr
function returns the position of the first occurrence of one
string within another string.
The reference documentation for this function is located here.
note
Note: This function works almost exactly in AtScale as described in the reference documentation. The exception is that Hive counts single unicode characters as two characters.