>>>>Hello,
>>>>
>>>>Which field type and length is appropriate to use as VFP Memo field in MSSQL?
>>>>
>>>>I created fields with type "text" and Fieldlength = 2^31-1, but when I query from VFP it does not return the field value, it shows blank.
>>>>
>>>>In MySQL I used Mediumtext which works fine with memo fields.
>>>
>>>I used text and varchar(max). I can't understand why you couldn't use text.
>>
>>Perhaps that is a driver problem, I use DRIVER=SQL Server Native Client 10.0.
>>
>>When I create a varchar(max) field the type shows as text:
>>
>>

>>ALTER TABLE TestTable ADD NewField varchar(max)
>>SP_Columns TestTable
>>

>>it shows:
>>

>>Type_Name = "test"
>>Precision =  2147483647
>>

>>
>>A query from VFP with the above mentioned driver shows a completely blank field, which I cannot open.
>>
>>When I copy to a table, it creates a character field with length 0!
>
>On the query from VFP
>

>SELECT ... CAST(NewField AS TEXT) as NewField ... FROM TestTable
>

This does indeed return the memo field, however it would be tedious to change all queries SELECT * FROM... !

I tried to find another driver, but it must be also working on 64bit.