You have to map them correctly. Search here in VFP, the problem was discussed already.

>I'm using SQL Server 2008 and the SQL Server Native Client 10.0
>
>I have read repeatedly not to use TEXT fields as they are being deprecated, use varchar(max) instead.
>
>When I use SQLEXEC() to do a simple select * from sometable
>the varchar(max) field always appears as a short empty character field in the resulting cursor.
>If, instead, I use a TEXT field type, the field appears as a memo field in the resulting cursor and the data is there?
>
>Any ideas?