>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.
In SQL Server 2005 and above I suggest to use varchar(max) as text type being deprecated. There are some problems associated with this type as how to get the values back in VFP.
If it's not broken, fix it until it is.
My Blog