>>how can I change the memo field into string and put into several data field ?
>>
>>When I change the data type from memo into char. All data are disappear .
>>
>>Please help
>
>Add few character fields with 254 char length. Then try:
>
>replace char1 with substr(myMemo,1,254) all
>replace char2 with substr(myMemo,255,255+254) all
>
>etc.
Note that this might very well split words. That's why I suggested mline().
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)