>Is there a way to write a SELECT-SQL statement so that one of the output columns is a memo type field? I know I can do SELECT "something" AS MyText, or SELECT 0000 as MyNumeric, or SELECT {} AS MyDate, but I can't figure out how or if it's even possible to get a column that's a memo type field.
>
>Alternatively, I have managed to use ALTER TABLE MySQLOutput ADD COLUMN MyMemo M or some other kluge, but once the ALTER table takes, I loose needed long field names.
>
>Any suggestions or ideas?

CREATE CURSOR MyCursor (DummyField M)
APPEND BLANK IN MyCursor

SELECT MyRealTable.*, MyCursor.DummyField FROM MyRealTable, MyCursor

With no join clause.