Here is what I have.....

SELE V_ANNDEMO **this is an remotve view to an sql table

sCATTER MEMVAR BLANK MEMO TO laBlank
m.visdate = ttod(v_anndemo.visdate)
m.formdate = ttod(v_anndemo.formdate)
m.xferdate = ttod(v_anndemo.xferdate)
m.date_ent = ttod(v_anndemo.date_ent)
m.date_val = ttod(v_anndemo.date_val)

FOR i = 1 TO FCOUNT()
lcFldName = FIELD(i)
luFldVal = EVAL(lcFldName)
REPLACE ALL (lcFldName) WITH laBlank[i] FOR ISNULL(EVAL(lcFldName))
ENDFOR

insert into v_old_anndemo ** this a remotve view into a 2.6 table
=tableupdate(.t.,.t.)

but the tableupdate fails ( it is capture with aerrors) and tells me that that still some fields with null values.....