Charlie,
How to work with Image field type on SQL Server (binary data)? FAQ #7995 by Vlad Grynchyshyn may help you.
>HI:
>
>I would like to be able to store Word documents in SQL Server. Since Word uses binary format, the SQL Server docs say to use an Image field.
>
>Currently, my VFP client uses Word automation to allow creation and editing of RTF docs. Using RTF, it is simple matter to open file and insert text into SQL string and send to database. This has been working well for a number of years, but RTF format can result in very large files if there are graphics.
>
>Switching to Word would be more efficient. How do you work with binary data? Can it be inserted into a SQL string? What options are available for searching an Image field for substrings?
>
>Thanx,
>Charlie
--sb--