Actually, you can do it this way ...
SELECT field1, space(255) as memofield FROM table1
(Jay: Please give me a call when you get a chance.)
>As far as I know, you need to join with a dummy cursor that already contains a memo field to do this.
>
>>Is there a way to add a memo field when selecting records from a table/cursor?
>>
>>For Example:
>>
>>
>>SELECT field1, space(4) as memofield FROM table1 INTO CURSOR cursor2
>>
>>In this example, I would like "MemoField" to be of Memo type in "cursor2".
>>Is there a way WITHOUT using CREATE CURSOR?