>I'm finishing a project that has "converted" fp 2.5 for DOS to VFP 9. One of the programs opens a table and copies it to a text file (type SDF). In 2.5 blank numerics were created with the replace command and copied to the text file as blanks. In VFP the numerics are, well numeric with a zero value which is then copied to the file. They want to see blanks again. I could open the text file and stuff the values but have been looking for a way to get VFP to either leave the blank numerics empty and/or copy them as blanks.

The behavior of COPY TO command is different in VFP. The numeric fields are copied to the text files as zeros regardless if they are 0 or empty in the table.