Re: What is the default search functionality for SPS search?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dan (dbauhaus_at_coveo-nospam.com)
Date: 01/28/05


Date: Fri, 28 Jan 2005 14:57:27 -0800


...or use an engine like Coveo Enterprise Search (free up to 50000 docs)
which does support AND and other advanced features like wildcard, custom
metatag search, phrases, etc.

-Dan

"lfastrup" <spameater@fastrup.dk> wrote in message
news:1106647887.084038.161650@z14g2000cwz.googlegroups.com...
> You will need to write your own search web parts to do this. SharePoint
> search shovels all keywords into a single SQL FREETEXT clause. It
> implicitly searches with OR between each keyword. E.g. searching for
> SharePoint Search will result in the following SQL:
>
> FREETEXT('SharePoint Search')
>
> But to search with AND instead of OR you need the following SQL:
>
> FREETEXT('SharePoint') AND FREETEXT('Search')
>
> It is as far as I know not possible to reconfigure the standard search
> web parts to do this. You will therefore need to write your own from
> scratch or try to extend the existing ones programmatically.
> Cheers
> Lars Fastrup
>



Relevant Pages

  • Re: What is the default search functionality for SPS search?
    ... You will need to write your own search web parts to do this. ... search shovels all keywords into a single SQL FREETEXT clause. ... SharePoint Search will result in the following SQL: ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: VSS with SQL server
    ... Just curious what SQL syntax file you're using ... The keyword list (Keywords 1) is SQL Server Reserved Keyword list. ...
    (microsoft.public.sqlserver.server)
  • Re: Searching for misspelled keywords?
    ... AKG wrote: ... > VARCHAR field of a table. ... > I know there is Full-Text Catalog in SQL Server but it doesn't suggest ... > Please note that I need to search for one or more keywords in VARCHAR ...
    (microsoft.public.sqlserver.programming)
  • RE: VBA variable to population Table Question
    ... Stuart posted the revised code. ... Dim SQL As String ... The single quotes delimit the text string. ... DoCmd.RunSQL ("INSERT INTO Keywords (ReferenceID, ...
    (microsoft.public.access.formscoding)
  • Re: searching on more than one field in VB
    ... information (keywords) into more than one of the seven textboxes and have any ... Much like SQL SELECT with multiple fields ANDed together. ... "Tom Ogilvy" wrote: ...
    (microsoft.public.excel.programming)