>Hi!
>
>Yes, you're correct, but there are many rocks on the way. See here FAQ#7995713 in Faq section -> Client/server -> "How to work with Image field type on SQL Server?"
>
>>Hi,
>>
>>What is the best way and the proper syntax to insert a word document from VFP into SQL Server 7.0 using SPT?
>>
>>Assume I have

lDoc = FileToStr("mydoc.doc")

How do I then insert up into SQL Server? Is "Image" the correct data type on SQL side?
>>
>>Thanks!

so - there's no way to convert a variable from a str to the proper type to insert directly into an image field on SQL? I would like to do this ...

lVar1 = FileToStr("myfile.doc")
lVar2 = SomeConversionFunction(lVar1)
SQLExec(n, [insert into mytable (docs) values (?lVar2)])