>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?
Try using mline() ( you may need to set the line size of the memo field to 250 first, if each field being 250 chars is a requirement, but if you just want to parse the memo field into character fields, try setting the char field sizes to 250 and using mline(i) to get each line into a field.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
