>Hello All,
>When I select fields from mytable can I add a blank memo field on the fly just as I can with characters( space(10) as charfield) and numerics (00000.00 as numfield)? If so, what is the syntax??
>
>Thanks,
>
>Sandy

You can make a trick here by joining one-record cursor with one empty memo field, but it's simpler just to call ALTER TABLE after your SELECT.