First occurrence:

SELECT CHARINDEX('s', 'Test string')

-------------------------------------------------

3

Second occurrence:

SELECT CHARINDEX('s', 'Test string', CHARINDEX('s', 'Test string')+1)

-------------------------------------------------

6