>Hi Russell,
>
>>SELECT *, SPACE(10) AS Dummy FROM MyTable
>>Will create a Dummy Field of C(10), How can I ensure that Dummy is a memo Field ? (Note SPACE(256) gives an error)
>
>
>You could try:
>
>CREATE CURSOR tempcursor (Dummy M)
>SELECT mytable.*, tempcursor.dummy FROM MyTable, tempcursor
>

Whoops. Remember to append a blank to tempcursor first i.e.

CREATE CURSOR tempcursor (Dummy M)
SELECT tempcursor
APPEND BLANK
SELECT mytable.*, tempcursor.dummy FROM MyTable, tempcursor

Best.

Matt.