INSTR

The InStr function returns the position of the first occurrence of one string within another string.

For more information on this function, refer to the Microsoft documentation.

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.