title: Looking for string using CHARINDEX
body: <p>I am required to use char index to locate a section of a word and to be the first 100 object it finds inside a database but for some reason, it is giving me several errors and have no clue what is wrong. I am trying to avoid using LIKE function.</p>
  <p>'''
  SELECT CHARINDEX('Harry', TITLE ), TITLE
  FROM Book
  LIMIT 100;</p>
  <p>'''
  It keeps saying it is an invalid identifier. I have looked at several sources but can't seem to figure out what is happening. Any help would be appreciated.</p>