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.