> what is the correct syntax in:
>

>  Select memo as MyMemo from table1 into cursor MyTable1
> 

>
> I want to add a memo field such as memo as MyMemo, like for example:
>
>

> Select Spaces(254) as Mytext from table1 into cursor MyTable1
> 

hi mike,
I'm not sure if this is what you want. the code below will create a cursor with all fields from a table (table1) plus a new field of memo type.

Create Cursor cursMemo (fldmemo m)
Select all table1.*,cursMemo.fldmemo as myMemo;
	from table1 left join cursMemo on .t.;
	into cursor withMemo readwrite

hope this helps,
Erik Gomez
www.foxite.com - The Home of The Visual FoxPro Experts
Long Live www.foxite.com