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