concat string and null

[#1]

Hello Team,

can you please advise how to replace nulls by a default value?

select concat(cast(glb.budget_version_id as string)," ", cast(glc.segment1 as string)) as balid
from oracle_financial.gl_balances glb,
oracle_financial.gl_code_combinations glc,
oracle_financial.gl_ledgers glg ;

If I add a null to a value, null will be returned.

I tried NVL it is not working.

Thanks,

Roshan

[#2 · Accepted solution]

On Oracle below works

select
concat(nvl(cast(glb.budget_version_id as varchar2(10)),0), cast(glc.segment1 as varchar2(10))) as balid
from gl.gl_balances glb,
gl.gl_code_combinations glc,
gl.gl_ledgers glg ;

Impala

[#3]

@roshanbi Is your issue resolved?

If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. 

mark as solution button