Freetext query to get surrounding portion of text

0.00/5 (No votes)

See more:

SQL-Server-2005

Hello all,

I want to build a Freetext query in sql server 2005 which returns some portion of the text around the matching criteria (word/phrase). That is, if i search for say, "valuable asset", the result should be something like "....positive attitude is the most valuable asset of a person, which....".

The column contains files of MS office 2007 (docx, pptx, xlsx,etc), html, txt and pdf formats.

Any suggestions?

Posted 18-Jul-11 4:30am

GeoNav

Add a Solution

Comments

Herman<T>.Instance 18-Jul-11 10:49am

suggestions....
will in your where clause a LIKE statement.
AND compare by casting to var_binary to seek in office docments.

GeoNav 19-Jul-11 12:21pm

I am sorry, but I did not follow your suggestion. I am able to find the documents matching the query. My requirement is to extract some text of the document where the search criteria is found.

dr.kitanjal 28-Nov-11 14:15pm

Please learn about full text index and use them

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Pete O'Hanlon	60
Richard MacCutchan	55
Graeme_Grant	35
Andre Oosthuizen	10
OriginalGriff	10

Pete O'Hanlon	2,305
OriginalGriff	1,683
Graeme_Grant	1,160
Richard Deeming	893
Dave Kreskowiak	839