FN-FORUM: SQL Server and Word Documents

date posted 1st April 2004 21:51

I have been searching google for a bit and have not got very far with this
one. I would like to store Word documents in SQL Server, I know I will have
to use the varbinary field (BLOB equivalent). But I would also like to be
able to search the word douments directly in the database.

If I store the word docs in binary format (base64 encode) then I guess I
will have problems searching them etc. Is it possible to store the documents
in SQL Server and be able to search them also or is this just not
possible???

Any help appreciated, I have found some stuff to do with asp but I am
looking at ASP.NET/c# in particular and have come to a bit of a dead end (is
it me or is it becoming more difficult to find relevant stuff with google
than it was 6-12 months ago......)


Best Regards

John Kyle