I have a question for you re: your advice on changing of the default value for your column. When I export to a text file I too will get /N for some records but not all the records in the same column. As I looked back, I have char fields as well as varchar fields in my table. They definately can't be set as not null in my situation, what can I change there default value to. I have tried empty string (“” or ''), but that doesn't seem to make a difference.
Any thoughts.