Fulltext Search

Dear Aall,
How can we search for all the key words? Is it possible to write a single
query with Freetext or Contains?
Example: if I search for 'Microsoft has released a new Operating System' I
should get the result which contains all the Key words in the phrase we
search.
Here in this example I should get the result set which contains all the key
words 'Microsoft', 'Released', 'Operating', 'System' in any order by
ignoring the noise words automatically.
Please give us your valid suggetions on this regards..
Thanks in advance
Sathian
Hi Sathian,
Try:
http://www.experts-exchange.com/Data..._20705253.html
The code may not be perfect, but with a bit of modification, you should be
able to get it to work for you to search for all the key words.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Sathian" <sathian.t@.in.bosch.com> wrote in message
news:dg8b86$cbn$1@.ns2.fe.internet.bosch.com...
> Dear Aall,
> How can we search for all the key words? Is it possible to write a single
> query with Freetext or Contains?
> Example: if I search for 'Microsoft has released a new Operating System'
> I
> should get the result which contains all the Key words in the phrase we
> search.
> Here in this example I should get the result set which contains all the
> key
> words 'Microsoft', 'Released', 'Operating', 'System' in any order by
> ignoring the noise words automatically.
> Please give us your valid suggetions on this regards..
>
> Thanks in advance
> Sathian
>