>sele yada from sql table into table tone1

Jeffery,

I would do

SELECT NVL(nField1, 0) AS Field1, ;
  NVL(cField2, SPACE(10)) AS Field2, ;
  NVL(yField3, $) AS Field3...

Be sure the width of the NULL value is the same as the desired width of the field. After this you can APPEND to your reporting table.