>>It should be varbinary(max)
>
>I believe there was a problem with varbinary(max) and we had to use TEXT instead? IIRC varbinary(max) fields return memo fields but they are empty and cannot be used, depending which ODBC driver you use.
I don't recall right now. I think we're using old SQL Server driver.
If it's not broken, fix it until it is.
My Blog