Full Text Search Help Required

• vineet.bhargava

  SSC Rookie

  Points: 40

  More actions

  October 3, 2011 at 6:01 am

  #245837

  Hi Below is my query which i'm using to full text search.

  declare @p_search_keyword varchar(100)='Iphone speakers'

  SET @p_search_keyword = '"'+@p_search_keyword+'"'

  SELECT mi.m_item_id , item_nm

  FROM dbo.tbl_item mi(nolock)

  WHERE

  CONTAINS( mi.item_nm,'FORMSOF(INFLECTIONAL', +@p_search_keyword+'")' )

  I dont know how to use it with FOrm Of its throwing syntax error can anyone help with the syntax

  Thanks

  Vineet BHargava

• Yuri55

  SSCrazy Eights

  Points: 8441

  More actions

  October 3, 2011 at 8:25 am

  #1389553

  I am not sure you can do this without dynamic sql as CONTAINS predicate has single quote inside for this case:

  CONTAINS(Description, ' FORMSOF (INFLECTIONAL, str_to_search) ');

  With dynamic sql it works like a charm