create cursorTemplate (IDField I, MyMemo M, MyNULL c(10) NULL, etc.) append blank select * from cursorTemplate where 1=0 ; union ; select ... from real tables>I am still using VFP 6, unfortunately.
SELECT SomeField, CAST (MyFunc (OtherField) AS N (10, 2)) AS CalculatedValue; >> FROM MyTable; >> INTO CURSOR Temp >>HTH
>>>select SomeField, MyFunc(OtherField) as CalculatedValue; >>> from MyTable; >>> into cursor Temp >>>>>>