doing a search

From: middletree (middletree_at_htomail.com)
Date: 05/11/04 

Date: Tue, 11 May 2004 16:13:39 -0500

Intranet tech support system using ASP/VBScript running on W2000 Server,
IIS, and using SQL Server 2000. I need to add a search engine. The problem
with using a regular SQL query is that if you put a phrase, say "red car" in
the text box, to hit submit, my SQL qurey would only look for that phrase,
and would leave out other items where the words red and car appeared
separately. I guess what I am saying is that I would like something like
Google or other search engines, which would find results which seem to fit
the criteria typed into the box, and rank them and highlight key words.

My research so far has shown me that SQL Server has something called
Full-Text searching, and I have tried to read up on that in BOL, but not
really seeing how I can apply it. I wonder if there's already some tutorials
or sample code out there. I have done some looking on the Web, but still
haven't found much. Does anyone here know where I can look? Having some
sample code would be best.

Relevant Pages

  • Re: Full Text Max Size?
    ... and depending upon what your is your SQL Server version and SP ... > from the OLE DB provider 'Full-text Search Engine'. ... > OLE DB error trace [OLE/DB Provider 'Full-text Search Engine' ...
    (microsoft.public.sqlserver.fulltext)
  • =?us-ascii?Q?Re:=20SharePoint=20Services=20=16=20SQL=202005?=
    ... It is strange that it does not work for you in SQL Server 2005. ... Try more general keywords. ... The search engine automatically includes variations of words based upon the ... > The reason is that WSS search uses SQL Full Text Search. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: How to Generate Snippets of the doc by Full-text Search Engine
    ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ... send the entire results back to the client and have the hit marked up ... Actually speaking, my system is just like a enterprise search engine, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Nested Nodes in XML from a table
    ... > Well considering that many persons would be accessing a search engine; ... > who knows how many of them will be in the future acessing at the same ... > is much faster than accessing the actual sql server. ... I don't have Books Online 2005 on this machine, ...
    (comp.databases.ms-sqlserver)
  • Re: doing a search
    ... > Server, IIS, and using SQL Server 2000. ... and rank them and highlight key words. ... Having some sample code would be best. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)