>Frank,
>
>It's been a little while but here is the statement that I've used in VFP to store a JPG file using FileStream -
>
>
lnRet = SQLEXEC(lnHandle, "UPDATE [alumnus] SET [ClassPhoto] = (SELECT BulkColumn FROM OPENROWSET(Bulk 'c:\temp\jpgs\MyFileName.jpg', SINGLE_BLOB) AS BLOB) WHERE AlumnusPK = 'MyPK'")
>
>HTH
>
>-Dan
Thanks, my co-worker was just asking me that, so I searched for your answer.
If it's not broken, fix it until it is.
My Blog