Exact phrase search

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.
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!
"JT" <jt@.jt.jt> wrote in message
news:#PrkQs8YEHA.2500@.TK2MSFTNGP09.phx.gbl...
> 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.