>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?
Renoir,
Perhaps you should consider mline() - I think this would break at word limits. In case this makes sense for your specific application.
Otherwise, you might also try padr() - I am not sure if this gives you a memo field.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)