MSSearch for words between two other words

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
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.
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
<calgarydatagrl@.gmail.com> wrote in message
news:1169569044.310656.316520@.s48g2000cws.googlegr oups.com...
> 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
>