Well,
I am a bit unsure if this is the right forum for the question. Still I will seek support...
I have a table which holds documents in varbinary(max) column. Full text search is enabled and works fine. Document formats include common MS office formats, pdf, html and txt. My requirement is to open the document and focus on the search criteria (word or phrase) in the document. I find the location of the search criteria in the document based on CHARINDEX.
Can anyone guide me?
Thanks