Actual word "NULL" in exported query results

Last Post 31 May 2004 06:09 AM by ChipDavis. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ChipDavis
New Member
New Member

--
31 May 2004 06:09 AM
Hi-

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:
Brian,NULL,Foley

Instead, I need the exported file to look like this:
Brian,,Foley

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.

Thanks,
Chip
You are not authorized to post a reply.

Acceptable Use Policy