|
-
Jan 6th, 2009, 05:13 PM
#1
SQL 2K5, Results To CSV, NULL Values?
When you try to save results in a grid to a csv file, whenever there are NULLs present, the value actually shows up in text as NULL in the CSV output. What can I do, if anything, to have it save as an empty field with nothing in it?
If I have data in three columns: 1, (null), 2
the result in the file is :1,NULL,2
where I want the output to be : 1,,2
Would make importing much easier to have nothing there than a NULL in text, especially in a numerical column.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|