>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
Join with a table that has a single record, with a single blank memo. I don't know of another workaround.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)