Sergey's solution is much simpler. Thanks anyway.

>Pre VFP9 solution would be:
>

>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.
>>
>>>Try

SELECT SomeField, CAST (MyFunc (OtherField) AS N (10, 2)) AS CalculatedValue;
>>>   FROM MyTable;
>>>   INTO CURSOR Temp
>>>

HTH
>>>
>>>>In a query similar to:
>>>>
>>>>

>>>>select SomeField, MyFunc(OtherField) as CalculatedValue;
>>>>  from MyTable;
>>>>  into cursor Temp
>>>>

>>>>
>>>>it may happen that MyFunc() returns .NULL. for some cases. If this happens, VFP informs me that the column doesn't accept NULL values.
>>>>
>>>>How do I make VFP allow null values? Of course, I could use NVL(...), but I do want NULL values in some cases, in order to know that there is some missing data.