Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: CONTAINS problems....


Message #1 by "Owen Mortensen" <ojm@a...> on Wed, 11 Dec 2002 10:51:14 -0700
I've just done a full index on a database that has full-text indexing
turned on.  However, SOME of the rows that match the contains clause are
not returned.

Example:
Select * FROM dbFile WHERE CONTAINS( dbColName, '"computed"')

Returns only a subset of the records I get when running the following
command:
Select * FROM dbFile WHERE dbColName LIKE '%computed%'

Any ideas as to why?

TIA,
Owen

OH, SQL Server 7.0 SP3 running on Windows NT Server SP6


  Return to Index