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