Search Full Text Indexes

• SJB42

  SSChasing Mays

  Points: 613

  More actions

  May 21, 2009 at 9:33 am

  #384635

  Hi all,

  Is it possible to use full text indexes to search for occurences of a word that have characters before it e.g. I want to find rows with 'fred' in them but some rows have 'fred' preceded with other characters i.e. xxxfred.

  Thanks,

  Stephen

• GRE (Gethyn Ellis)

  SSCrazy Eights

  Points: 9602

  More actions

  May 24, 2009 at 3:56 pm

  #999514

  I think, but entirely sure that you can do this using the LIKE statement...at least accordng the BOL entry:

  http://msdn.microsoft.com/en-us/library/ms187787.aspx

  Not sure yout going to get the full performance benefit of Full text using this approach though.

  Gethyn Elliswww.gethynellis.com