Full Text Search

• mah_j

  SSCrazy

  Points: 2931

  More actions

  December 22, 2014 at 2:04 am

  #293247

  Hi

  How can I search for rows containing a word ending with sth. with Full Text Search.For example the word code :

  personelCode:100#personel.TimeStamp:2014/12/17 16:47:52#message timeStamp:2014/12/17 16:47:52#

  For starting with personel we have :

  SELECT *

  FROM TableName

  WHERE CONTAINS(ColumnName,'"code*"')

  But we can not use CONTAINS(ColumnName,'"*code"') for ending with...