>Is there a quick way to replace all the fields in a record that have a .Null. value to a blank value of the field's type, i.e. " " for char, 0 for numbr, .F. for logical, etc.? If it is easier to do this in an array, please let me know.
>Thanks!

local lnI, lcWhere
scatter memvar blank
for lnI  =  1 to fcount()
  lcWhere = field(lnI) + " IS NULL"
  replace field(lnI) with evaluate("m." + field(m.lnI)) for &lcWhere
next