All Forums General
Vinay151 20 posts Joined 12/14
14 Jul 2015
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.
 

Glass 225 posts Joined 04/10
15 Jul 2015

Vinay,
You can use coalesce.
 

coalesce(col1, '') ||col2
 
 
Rglass

You must sign in to leave a comment.