>Hi all
>
>I have a cursor created using SQL PT, in which I have a remarks field, of which I am getting the first 100 characters using CAST(fld AS CHAR(100)) but it is always coming up as a memo field. Whereas the same VFP counterpart code is bringing in the remarks column as a character 100 field.
>
>Can you please let me know how I can convert the memo field to a text field except for creating a second cursor in VFP again from the SQL PT cursor.

What does:

? CURSORGETPROP("UseMemoSize",0)

return? To return that as a char value that should return something over 100. ie:

CURSORSETPROP("UseMemoSize",250,0)

Cetin