>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.