>>>I still haven't found a good workaround for Text. It is deprecated since 2005, but still exists in SQL 2016. I wonder how long it will stay around?
>
>VARCHAR MAX is the recommended replacement for TEXT and VARBINARY MAX for IMAGE. As for how long deprecated field types stick around: maybe as long as VFP? ;-)

The problem is that if you use SQL Pass-Through, Varchar(max) fields comes over as blank fields.