Posted by Jayce Ooi as Programming
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.