Concatenating null with a value

General

Concatenating null with a value

Hi,

I have a null column and I'm concatenating that null column with a column has some values. But my output is null. Is there any way to overcome this?

Thanks,

Vinay.

1 REPLY
N/A

Re: Concatenating null with a value

Vinay,

You can use coalesce.

coalesce(col1, '') ||col2

Rglass