When I run a query in Query Analyzer, often a portion of my results are missing the value of some fields, which then appear as NULL. This is fine.
But, when I export the results, the actual word 'NULL' appears in my export, e.g. if Brian is missing a middle name, i get:
Instead, I need the exported file to look like this:
Is there an option within QA for this, or something else I can do? I'm currently exporting the results by rightclicking on the results array and doing a SaveAs comma delimited.