CHARINDEX (Transact-SQL)

CHARINDEX (Transact-SQL)

0

What is CHARINDEX use for? It will return the starting position if the searched value is found. For example,

CHARINDEX (SearchedValue, StringToBeSeached)

StringToBeSeached == “I like to eat durian”
SearchedValue == “eat”

The result will be ’11’. The word “eat” start on index 11.