Full text search returns no results

• sarank

  Newbie

  Points: 3

  More actions

  December 20, 2002 at 2:47 am

  #80559

  Hai everybody,

  I have a table with text column. The structure is

  TblData

  -----------

  LngIdnumeric(20)

  VchNameVarchar(100)

  VchEmailVarchar(100)

  TxtDataText

  VchRemarksVarchar(1000)

  I have created a catalog in the DB and added the table and column. I also started the full population of catalog. But when i issue a query(like the one i have given here) no data is returned even if theres a matching row. No error is also reported.

  select * from TblData where CONTAINS(TxtData,'ASP')

  But when i issue a simple query like

  select * from TblData

  rows are returned.Pls help me.

  Regards,

  Saravanan K

  Regards,

  K.Saravanan

  
  Regards,
  K.Saravanan

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  December 23, 2002 at 4:40 pm

  #445072

  Is the population complete? Good? Corrupt file will give bad results, worth checking.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn