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?