question Re: concat string and null in Support Questions

concat string and null

roshanbi — Tue, 13 Jul 2021 07:00:27 GMT

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

Re: concat string and null

roshanbi — Tue, 13 Jul 2021 07:09:28 GMT

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

Re: concat string and null

cjervis — Wed, 14 Jul 2021 12:52:24 GMT

@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.