troubleshooting Question

Free text search in Word/Excel etc stored in BLOB

Avatar of Stefan Lennerbrant
Stefan LennerbrantFlag for Sweden asked on
Microsoft SQL Server
11 Comments1 Solution515 ViewsLast Modified:
I'm storing Word and Excel (and other) documents in BLOBs in SQL Server 2000, alongside with various other simple varchar fields.
Today I search for text data in the varchars with simple
 ...where field like '%text%' or field2 like '%text%'
It has not yet been interesting to start using the real free text search functions in SQL.

However, now I'd like to perform searches in at least Word documents, perhaps also Excel and PDF and perhaps also other types.
We are in full control of the application performing the searches (in-house developed in C and C++) and thus I look for some product that may perform these searches and return indications of which rows match.

Either a module that may compiled or linked into our program, or alternatively an external EXE program that takes some input and gives some output that may be written/read by our application.

Also, I may of course use the freetext capabilities and transfer the documents into those tables when storing them initially.
Then I'd need some module to extract the data from the documents.

Any ideas or experiences of document free text search?
Thanks, /Stefan Lennerbrant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros