RE: string concatenation

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
>