Hi!

Take a look to the FAQ#7995. You can use 2 approaches - with converting general type to memo using low-level working with file, or use ADO to query binary data (that is also another connection to SQL server).

nulls is not a problem - you can store file with any kind of bytes in it into a VFP string with a great success. Take a loo to strtofile and filetostr() functions to see approvement of this.

Let me know if you have further questions - I worked out this (working with binary data) quite well...

>When using SQLEXEC command to return a binary field from a SQL Server it comes back as a gen data type. Trying to save the field to a string, so I can use the STRTOFILE command but I get the error when using the following command.
>
>
>SqlServer = SQLCONNECT("sqlServer", "userid", "Password")
>rc = SQLEXEC( sqlServer, "SELECT binaryField From sqltable", "mycursor")
>
>lcSting = myCursor.Binaryfield <-- Error
>
>
>I think the problem is, the binary field is around 8000 char, and also has nulls in it.
>
>Is there another way to retieve binary fields from SQL Server?
>
>I need to be able to read/change the field and update the table on the SQL Server.
>
>Thanks for the help
>
>Rex A. Walters