Hallo everybody

If I want an extra character field in an SQL select I can write:
SELECT * ,SPACE(10) AS cFIELD1 FROM SOURCETABLE INTO TABLE RESULT

If I want an extra numeric field in an SQL select I can write:
SELECT * ,000000 AS nFIELD1 FROM SOURCETABLE INTO TABLE RESULT

But! How do I write if I want an extra memo field in an SQL select???

I hope someone can help me.
Thanks in advance
/Kjell