BCP And Treatment Of NULLs When Export To Fixed Format Text File

We are using the bcp utility (via APIs) to export data from a SQL table
in a fixed format text file. BCP is inserting spaces for a field if
the field contains a NULL. This is fine with us except at the end of
the line, there are no spaces for that field just the end-of-row
terminator prematurely, so it looks like that field is not present and
messes up another piece of software we pump the text file into down
stream.

Example -- The last row illustrates the problem.

123-49-890 Mary Smith Raleigh NC

999-88-123 Henry Ax Boston MA

456-99-123 Sue Kite WA

789-88-126 Andy Yates Philadelphia


We have thought about using a SQL query to convert the NULL data
explicitly to spaces, but were wondering is there a switch or something
in our format file to get around this.

Thanks.