USE xldata in 0 USE nan in 0 DELETE ALL fields EXCEPT char19&& how i can do this select xldata SCAN SCATTER memvar *!* either append blank or seek correct record to update SELECT NAN *append blank && i need to replace (delete all data replace new data) replace all GATHER memvar field EXCEPT char19 ENDSCANthanks.