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

---

Fred,
Should it be strictly one SQL "select" ? Append from instead ? ie:

create cursor memotable (mfield M)
select cfields as mfield from chartable into cursor transfer nofilter
select memotable
append from dbf("transfer")

Cetin