I am using the "COPY TO TYPE DELIMITED" command to created a comma separated text file for importing into another program. Some of my fields are numeric and are empty OR null in the originating table. They are converted to ZERO in the comma deilimited file. I need them to be nothing, no character, just a place holder. I do not want to bring in the zero value into the new program. In other words I need the file to look like this:
"Good Retest 1 Year",,,,,,,,
not like this:
"Good Retest 1 Year",0,0,0,0,0,0,0,0
However, when there is a zero in the originating field, I do want that one to be there.
I've racked my brain on this one. Help is very much appreciated.