Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / July 2004

Tip: Looking for answers? Try searching our database.

Exact phrase search

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JT - 07 Jul 2004 03:28 GMT
This question concerns searching in a windows sharepoint services site.
 I have posted the question there and have been advised to post it here
instead.

As WSS uses 100% standard SQL Server 2K full-text search, is it possible
to do an exact phrase search? If it is possible, what should be the
search string entered into the search box?

Any help would be greatly appreciated. Thanks.
John Kane - 07 Jul 2004 04:54 GMT
JT,
Good to know that this newsgroup is providing helpful info and is being
cross-newsgroup referred! :-)

The answer to your question is yes. You would need to use CONTAINS vs.
FREETEXT that WSS uses. If you have access to the query or stored procedure
that WSS uses or if you have your own custom WSS search stored procedure,
you can either use the T-SQL REPLACE and "replace FREETEXT with CONTAINS or
substitute CONTAINS for FREETEXT in your SQL FTS Query. Below is a CONTAINS
query with an exact phrase search using the Pubs database and pub_info
table:

use pubs
go
select pub_id,pr_info from pub_info
where CONTAINS(pr_info, '"Moon Books"')
/* -- returns:
pub_id pr_info
------ --------------------------------------------
0736   This is sample text data for New Moon Books,
(1 row(s) affected)
*/

Regards,
John
PS: If you need help with your WSS query and replacing freetext with
contains, please post your code in your reply!

> This question concerns searching in a windows sharepoint services site.
>   I have posted the question there and have been advised to post it here
[quoted text clipped - 5 lines]
>
> Any help would be greatly appreciated. Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.