Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Index Server Search Query

Author  Topic  Dion Starting Member 1 Post Posted - 2002-11-25 : 17:09:14 Hey guys, I'm having trouble getting my head around the query language for an Index Server Search - although not exactly a "SQL Server" problem, I believe it's my bad query causing the problem. I have some dummy content pages that have text like "this file contains things" and "this file contains stuff". I've tried these two queries: ============= SELECT DocTitle, VPath, Path, Filename, Rank FROM SCOPE('DEEP TRAVERSAL OF "c:\inetpub\wwwroot\"') WHERE ((CONTAINS(' "file contains" ') >0) AND ((Path NOT LIKE '%\_vti%') AND (Path NOT LIKE '%\_private%') AND (Filename NOT LIKE 'search.asp'))) ORDER BY Rank DESC ============= And: ============= SELECT DocTitle, VPath, Path, Filename, Rank FROM SCOPE('DEEP TRAVERSAL OF "c:\inetpub\wwwroot\"') WHERE ((CONTAINS(' "file" AND "contains" ') >0) AND ((Path NOT LIKE '%\_vti%') AND (Path NOT LIKE '%\_private%') AND (Filename NOT LIKE 'search.asp'))) ORDER BY Rank DESC ============= With neither returning results. If I query just "file" or "fil*" I get matches fine. Also, if I query "*ile" I get no matches. Any idea where I'm going wrong? Any help would be very much appreciated.