• Tweet

• Tweet

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.