Toad World® Forums

Space instead of {null} in data result

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

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

then the following query

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

returns
image

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

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