1

Regarding this SQL Server Full text Search topic, I could save my files in binary data type and my problem was solved.

Now, after saving files in the database I have a new problem.

After searching, I need to find the location of the criteria (For example in which lines or which columns) and highlight those.

I suppose this is very important that we can find the location of the criteria text in files and show them to the users.

I appreciate any help.

Community
  • 1
  • 1
Pars.Engineer
  • 57
  • 2
  • 8
  • Possible duplicate of http://stackoverflow.com/questions/3662419/how-do-i-get-the-position-of-the-match-in-a-formsof-inflectional-full-text-searc – Strillo Jan 19 '12 at 12:05

2 Answers2

0

I needed this code and called Christopher to get. He posted it on his site It can be downloaded from the message .Net Search Result Highlighter for SQL Full-Text Search

I used it and it is working good

Vajra V.
  • 1
  • 1
0

Till SQL Server 2005, I don't think there is any built-in function for this.

Anyways, check out Christopher Felpel (VB.NET based) solution for highlighting the search string - http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/2e18958f-cdb9-4689-8a88-0af471963479

vmvadivel
  • 1,041
  • 5
  • 7