Export NULL values as blank, not 0 (zero)

SQL Navigator
1

I have a script to track items in the database that have blank cost values. When I run the script shows as expected for those instances. However, When I export the records as text, delimited text, or excel the output populates those values as a 0 (zero). How can I get the export to popluate those values as a blank record? Message was edited by: JElliott

Message was edited by: JElliott

CPU.png
CPU.png771×426 28.8 KB

2

Hi JElliott,

I think we got this issue in version 6.1 and 6.1.1 but it has been fixed in 6.2. Unfortunately, I couldn’t find any workaround for it.

Gwen