What if instead of CAST(fld AS CHAR(100)) you just send substring(fld,1,100)?
Enmanuel
>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.
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain