Equivalent of INSTR of Oracle in SQL Server

Hi all...

There is an equivalent of INSTR of Oracle is,


As there is extra parameter in oracle as next occurrence .. it is not available in SQL Server..

ORACLE	SQL SERVER
Select INSTR('TEST_A,TEST_B','_') from dual	Select CHARINDEX('_','TEST_A,TEST_B')