MSSearch for words between two other words

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

calgarydatagrl@gmail.com - 23 Jan 2007 16:17 GMT

I've been asked to find a way of doing some complex searches against a
SQL Server 2000 database using MSSearch.

The company I'm contracting to wants to know if there is a way to
perform a search such as:

"sql" within x number of words of "database" (x could be any number)

I'm not that versed with any more than the basic searches within
MSSearch, so this one's a stumper for me. Any help on this would be
appreciated.

They are using ColdFusion to develop the interface between the web and
the database.

Thanks,
CalgaryDataGrl

Reply to this Message

Hilary Cotter - 23 Jan 2007 18:05 GMT

Hey Calgary Data Girl - I used to live in Calgary - born in Edmonton, and
lived in the nwt for some time!

To answer your question - no, they do have the near operator but it doesn't
define how near. Other search products (like Indexing Services) does allow
you to define the separation in terms of number of words, lines, paragraphs,
pages and chapters.

Signature

Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> I've been asked to find a way of doing some complex searches against a
> SQL Server 2000 database using MSSearch.
[quoted text clipped - 13 lines]
> Thanks,
> CalgaryDataGrl

Reply to this Message