Superb Dan!

>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
>
>>Hi,
>>
>>I am using FileStream in my SQL Server 2008 R2 database to store a PDF. I use this code:
>>
>>

UPDATE Claims
>>	SET clm_Scan = CONVERT(VarBinary(max), N'MyFileName.pdf')
>>	WHERE clm_PK = 'MyPK'

>>
>>I want to let the user now view the PDF, so I query the clm_scan field then use STRTOFILE() to create the file oon my disk, but when I try to open the PDF I get a message that "Adobe Reader could not open the file because it is either not a supported file type or because the file has been damaged..."
>>
>>Am I doing this right?