>OK Michel, you've made me actually "think" on this one.
>The problem seems to be when you combine data from two memo fields, the corresponding field type returned from SELECT is a character field and NOT a memo field. Character field can only hold 254. So here's what you have to do:
>
>1. Create a cursor with a memo field to hold the data you're going to use for combining the 2 memo fields.
> CREATE CURSOR c1 (memo m) You could enter more fields if you like.
>2. SELECT memo1, memo2 FROM mytable INTO CURSOR c2
>3. Use looping (DO WHILE, SCAN, etc) and issue INSERT INTO c1 (memo) VALUES (c2.memo1+c2.memo2) inside.
>
>Is this too much work for what you're trying to do?
Thanks for the suggestion.