SQL Server String Index Functions

DECLARE @string VARCHAR(50)
SET @string = 'This is mohan from IT'

LEN
PRINT len(@string)

CHARINDEX
PRINT charindex('is', @string) -- 1

PATINDEX
PRINT patindex('%m___n%', @string)

STUFF
PRINT stuff(@string, 6, 2, 'xx')