# Space instead of {null} in data result

**URL:** <https://forums.toadworld.com/t/space-instead-of-null-in-data-result/52728>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [May 4, 2021, 6:43pm UTC](https://forums.toadworld.com/t/space-instead-of-null-in-data-result/52728 "2021-05-04T18:43:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![minuzz](https://avatars.discourse-cdn.com/v4/letter/m/4af34b/32.png) [@minuzz](https://forums.toadworld.com/u/minuzz)\
**Post date:** [May 4, 2021, 6:43pm UTC](https://forums.toadworld.com/t/space-instead-of-null-in-data-result/52728/1 "2021-05-04T18:43:34Z")

</div>

Is there a way to edit the query (or what query) for using space instead of {null}?

I am trying to use IFNULL(id,' '), but it is not working.

Thanks in advance.  
Min

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [May 4, 2021, 8:35pm UTC](https://forums.toadworld.com/t/space-instead-of-null-in-data-result/52728/2 "2021-05-04T20:35:27Z")

</div>

May want to look at the database's function library to be sure of which function (and parameters) are supported. For example, your example might work on Oracle, but say, for SQL Server, the function to use is "IsNULL".... so for the following table:

SELECT FirstName, LastName, MiddleName from GJ\_DimCustomer...  
 ![image](https://global.discourse-cdn.com/quest/original/2X/e/ed28ba7a510ec35bc06658380518bc22bf0807fe.png)

then the following query

```
SELECT FirstName, 
        LastName, 
        IsNULL(MiddleName,' ') MidName 
        from dbo.GJ_DimCustomer

```

returns  
 ![image](https://global.discourse-cdn.com/quest/original/2X/0/067884d6f8e0131cc8fd8bc6797cb8db901b7005.png)

---

<div class="post-metadata">

**Author:** ![minuzz](https://avatars.discourse-cdn.com/v4/letter/m/4af34b/32.png) [@minuzz](https://forums.toadworld.com/u/minuzz)\
**Post date:** [May 4, 2021, 8:53pm UTC](https://forums.toadworld.com/t/space-instead-of-null-in-data-result/52728/3 "2021-05-04T20:53:12Z")

</div>

Hi Gary,

Thank you for your response.  
I am querying from Oracle and using the code below, but IsNULL is not working.  
I've got this error message: "ORA-00904: "ISNULL": invalid identifier"

![image](https://global.discourse-cdn.com/quest/original/2X/d/d55a6361755d7c680f35ae36c1fff4497bbf2b2e.png)

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [May 4, 2021, 11:23pm UTC](https://forums.toadworld.com/t/space-instead-of-null-in-data-result/52728/4 "2021-05-04T23:23:24Z")

</div>

You'll need to check your Oracle database's documented functions, as there are probably several ways to display blanks vs NULLs. Probably easiest function to use is NVL()... So, given your example above, try

SELECT VIEW\_LPAY.tran\_id,  
**NVL( VIEW\_LPAY.lby\_activity, ' ')** LBY\_ACT\_NULL  
FROM CLAIMS.view\_lpay VIEW\_LPAY
