select MYFIELD1, MYFIELD2, CAST(space(10) AS memo) as MYNEWFLD from MYTABLE

Before VFP9 see Re: Adding memo field as calculated field Message #683252

>I want to add an empty field to the cursor created with SQL Select.
>The field should of memo type, so that later it can be populated.
>
>For example, if I wanted the field to be of char type I would do the following?
>
>

>select MYFIELD1, MYFIELD2, space(10) as MYNEWFLD from MYTABLE
>

>
>But what would I put in the place of "space(10)" if I want the MYNEWFLD to be of memo type?
>
>I realize I can add the field after I create the cursor, but I am curious if it is possible to do in one expression.
>