Null to string 1

[atmosphere]

Hi

i have to concatenate a few strings in a select statement.
one string has the possibility of being null. Apparently in db2, if you concatenate strings and one is null, you recieve null. In this case i just want the null string to be "". Is there anyway i can do this?

 

[sathyarams]

cola||coalesce(nullcol,'')||colb

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp