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.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
  • StumbleUpon
  • Technorati
  • Reddit
  • Facebook
  • Google
  • Live
  • YahooMyWeb
  • Furl
  • Slashdot
  • Spurl
  • Mixx
  • BlinkList
  • Bumpzee

Tags: