# NAN

**URL:** <https://forums.toadworld.com/t/nan/3944>\
**Category:** SQL Navigator\
**Created:** [September 15, 2009, 8:40am UTC](https://forums.toadworld.com/t/nan/3944 "2009-09-15T08:40:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![RadarAutomation](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@RadarAutomation](https://forums.toadworld.com/u/RadarAutomation)\
**Post date:** [September 15, 2009, 8:40am UTC](https://forums.toadworld.com/t/nan/3944/1 "2009-09-15T08:40:40Z")

</div>

Hello,

When I export some selected data as spool text, some columns with NULL values are indicated as being “NAN”, some are not. What I did to reproduce this phenomenon, and the results:

CREATE TABLE x ( c1 NUMBER(1), c2 NUMBER(2), c3 NUMBER(9), c4 INTEGER, c5 NUMBER(4, 1));  
INSERT INTO x VALUES (1, 1, 1, 1, 1);  
INSERT INTO x VALUES (2, NULL, NULL, NULL, NULL);  
INSERT INTO x VALUES (NULL, NULL, NULL, NULL, NULL);

SELECT \* FROM x;

– CTRL-E in the results tab, Format: “Spool Text”

C1 C2 C3 C4 C5

* * *

```
     1 1 1 1 1
     2 NAN NAN
   NAN NAN NAN
```

---

<div class="post-metadata">

**Author:** ![RadarAutomation](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@RadarAutomation](https://forums.toadworld.com/u/RadarAutomation)\
**Post date:** [September 15, 2009, 8:45am UTC](https://forums.toadworld.com/t/nan/3944/2 "2009-09-15T08:45:02Z")

</div>

Ahem, the formatting is pretty much gone in my previous message. I’ve attached a text file that should have the formatting preserved…  
[B91\_01.txt](https://global.discourse-cdn.com/quest/original/2X/4/49407181188ab1763745e1e48bd4b1f0ee9373e6.txt) (875 Bytes)

---

<div class="post-metadata">

**Author:** ![bruceduong](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bruceduong/32/69_2.png) [@bruceduong](https://forums.toadworld.com/u/bruceduong)\
**Post date:** [September 15, 2009, 7:57pm UTC](https://forums.toadworld.com/t/nan/3944/3 "2009-09-15T19:57:08Z")

</div>

Hi Dominique,

Thank you for your note. This has been reported earlier. Roman has already made changes to fix this issue, and it will be in the first build for next Beta round in a near future.

Thanks and regards,  
Bruce

---

<div class="post-metadata">

**Author:** ![RadarAutomation](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@RadarAutomation](https://forums.toadworld.com/u/RadarAutomation)\
**Post date:** [September 16, 2009, 2:22am UTC](https://forums.toadworld.com/t/nan/3944/4 "2009-09-16T02:22:37Z")

</div>

Sorry to re-report the issue - eagerly awaiting the next beta!

---

<div class="post-metadata">

**Author:** ![RadarAutomation](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@RadarAutomation](https://forums.toadworld.com/u/RadarAutomation)\
**Post date:** [September 15, 2010, 3:03am UTC](https://forums.toadworld.com/t/nan/3944/5 "2010-09-15T03:03:47Z")

</div>

Browsing through my older posts, I found this problem - it is fixed in 6.4.0.1901 (and probably in several previous releases, too).