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
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...
then the following query
SELECT FirstName,
LastName,
IsNULL(MiddleName,' ') MidName
from dbo.GJ_DimCustomer
returns
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"
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