Hi,

I ve a varchar variable(say Var1 ) which may be not initialized or may have a null value., when i concatenate this variable with any other varchar variable (say Var2 = 'SAMPLE') which has a valid string as a value., the result obtained is null.

ie.,

result = var1 || var2 returns null to result

In DB2 is there anything similar to SQL Server's

SET CONCAT_NULL_YIELDS_NULL { ON | OFF }

this option when set to OFF returns the non null string and returns null when set to ON.

Regards
Sn

Do not know of any such config parm ..

You can do coalesce(var1,'')||coalesce(var2,'')

Cheers
Sathyaram

Thanks for the reply Sathyaram, I ve plenty of such concatenations and hence the usage of COALESCE will be tedious, is there any other work around.

Sn