SELECT *, .F. AS LogicField, SPACE(50) AS CharField, 000000.00 AS NumField ;FROM mytable INTO CURSOR mycursor.