Does anybody know how to do SQL SELECT statement that will move data from a character type field and move it into a memo field in the cursor?

This is not trying to pull data from an existing memo field, but trying to create a new memo field that is populated with the data from the character field and will be massaged later on in the code.

CREATE CURSOR memotable (mfield M)
INSERT INTO memotable (mfield) VALUES ('')
SELECT mfield FROM memotable ;
       UNION (SELECT cfield FROM chartable) ;
       INTO CURSOR memocursor

gives a UNION INCOMPATIABLE ERROR.

Any suggestions?