>>Nice idea, but:
>>
>>ODBC Error Message: [[Microsoft][SQL Server Native Client 11.0][SQL Server]Explicit conversion from data type text to varbinary(max) is not allowed.]
>>
>>According to what I've been able to find online, conversion from text to varbinary(max) is implicit (hence the error above).
>>
>>
https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql#large-value-data-types>>
>>I've looked at SQLSETPROP() for any connection properties that might affect this, I didn't see anything that might be applicable.
>
>Hmm, I think it worked for me a while ago:
>
>
http://blogs.lessthandot.com/index.php/datamgmt/datadesign/dealing-with-the-the-text/Thanks - following your link, then Cetin's on Foxite I found CREATEBINARY( ), which works properly for me - see my response to Antonio.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
