You can create a cursor with memo field and add it to select.
CREATE CURSOR crsTemp (Notes M)
APPEND BLANK
SELECT * ;
FROM sourcetable, crsTemp ;
INTO CURSOR crsResult
>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
--sb--