Hello, as mentioned in a mail by Elke yesterday, using VALUE(c1, '') may be what you want. See
http://listserv.sap.com/pipermail/sapdb.general/2003-August/040314.html and http://www.sapdb.org/7.4/htmhelp/cf/633171c03511d2a97100a0c9449261/content.htm Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Jens Stier [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 28, 2003 1:36 PM > To: [EMAIL PROTECTED] > Subject: string concatenation > > > hi there, > > > i have two column c1 and c2 > > in a select statement i concatenate both of them: > > select c1&', '&c2 from tbl > > here my problem: if one of the columns is null, the > concatenated string c1&' > '&c2 is also null, no matter what the other column contains. > > > is there another way to concatenate two columns in a select > statement? maybe > an sth. like > > if(c1 is null) > then c2 > else c1&', '&c2 > > > ?? > > > > thx > J > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
