how to search containing word using "Free Text Search" like %[word]%

• Vijay A

  Grasshopper

  Points: 23

  More actions

  August 9, 2011 at 6:45 am

  #245761

  Hi,

  Is it possible to search the middle word using free text query similar to %[word]% using in T-SQL.

  For example, search for word "ita" or "ital" should return record value having "Vital".

  Regards

  Vijay A

• GregoryF

  SSCertifiable

  Points: 6296

  More actions

  August 9, 2011 at 6:49 am

  #1365849

  Select * from table where column like '%word%'

  /* ----------------------------- */
  Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

• Vijay A

  Grasshopper

  Points: 23

  More actions

  August 9, 2011 at 7:12 am

  #1365874

  Thanks for the reply but i am using "Free text search" not the normal T-SQL. I need query using Key Word "ContainsTable".