Update: I am now using Isnull for all data of type numeric and money. I'm still getting garbled output, which begins when I add to my select list a particular field of type char (which is NULL in my table).

However, if I comment out a bunch of fields early in the select list and retain that particular field of type char, the output looks fine! :w00t:

So apparently BCP does have a maximum length per line issue. Does anyone have an idea how to tell BCP to accept a real wide line of output?

thanks,