freetexttable

• sql_2005_fan

  SSCommitted

  Points: 1871

  More actions

  February 15, 2007 at 3:01 pm

  #116213

  When I run the first query I am getting the data for the emp_id 'lmc_1234'.

  But when I run the second query I am not getting any data. what could be the reason.

   

  query1: SELECT * FROM emp WHERE emp_id='lmc_1234'

  query2: SELECT * FROM FreetextTable(emp,*,'lmc_1234')

   

  Thanks.

• David McFarland

  SSChampion

  Points: 11815

  More actions

  February 15, 2007 at 8:44 pm

  #690119

  Not trying to be Captain Obvious here, but have you turned on full-text indexing on the database, table, or column?