Not sure if this is an answer to your question but check Re: Blob Datatype (getting image from SQL)... Thread #1259045


>Hi,
>
>I am converting my data from VFP Database to sql, with vfp we adding a general field to have an image. but with sql we use a varbinary col. to store the image as i know.
>
>the adding image statement i use as follows:-
>
>CREATE TABLE myTable(Document varbinary(max))
>INSERT INTO jbm(Document)
> SELECT *
> FROM OPENROWSET(BULK N'C:\Garden.jpg', SINGLE_BLOB) as document
>
>
>is there any example for using sql to store an image.
>
>Best Regards