Tim,

Check Varchar(MAX), Memo fields, SPT and Remote Views Thread #1284904. Looks like it's other way around. The VARCHAR(MAX) works correctly with the SQL Server ODBC Driver but not with the SQL Server Native Client.

>
>>
>>What is the version of SQL Server ODBC Driver you're using? Make sure that you're using SQL Server Native Client.
>
>
>We are using the SQL Server Native Client. I am fairly certain I downloaded it from Microsoft in November
>
>Varchar (max) is the problem. There is a varchar (75) field in another table and it comes down from SQL Server using SPT just fine. In the SQL Server SELECT I did a CAST of the varchar (max) field to a char (8000) and it came down through SPT as a memo field. We can probably live with that as a work-around. It would be nice not to have a work-around.
>
>Any more thoughts?
>
>
>Tim