>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?

Is there a reason you have to do this in one step? I don't think its possible. You've already come up with the only way I know of to even get a memo field in SQL results- I think you're going to have to use this along with a second step that populates the memo field.