So 10 minutes, of playing with your code. and it works. Works like it shoud.
makes perfect sense. !

Thank you Thank you.
Bob Lee


>Hi!
>
>Who did recommended you such thing? Binary data could be stored on SQL Server without converting them into the HEX string format. Just use the IMAGE field type on SQL Server to store binary data. If you use views, than just map the appropriate view field in te view field properties dialog box to use Memo field type. In VFP memo field can store any binary data without a corruption. Than use FileToStr() and StrToFile() functions for file<->memo. When you use SQL Pass-Through - this is somewhat tricky because VFP create General field type for image field on SQL Server. How to workaround this - read in the FAQ#7995. Using that approach with SQL Pass-Through I managed to get 2.5 MB BMP image file from MSDE SQL Server within 1 second.
>