CharIndex in SQL Server

CharIndex in sql server gives you position of particular character.
See Example below :

Declare @test VARCHAR(3)
SET @test = 'abc'
SELECT CharIndex('b',@test) as 'Position'