>Use a SQL statemetn, I was trying to break a Memo field into blocks of 250 characters, but when I used SUBSTR(MyMemo,1,250) I get another Memo field. If I use LEFT, it returns a Character field. I need to get about 10 blocks of 250 characters. This needs to be quick and easy, that's why I didn't try to do the OLE thing. Any thoughts?
Yes, before VFP9, the only function that preserve Memo datatype it is SUBSTR()
To force character conversion:
LEFT(MyMemo,250)
SUBSTR(MyMemo,N,L)+''