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: 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.