concat two strings

From: (wrong string) ürg Schaufelberger <juerg.schaufelberger_at_tele2.ch>
Date: Thu, 11 May 2006 20:27:04 +0200
Message-ID: <mlL8g.169$OK3.41_at_nntpserver.swip.net>



Hello

[Quoted] I need a function to concat two strings only if both values are not null. The concat() doesn't work like this and the operater || either.
I would like to concat the strings in a SQL-statement. Is there in Oracle 9 a function that works like I need it ? What's the easiest way to solve this problem ?

Thanks for your help
Jürg Received on Thu May 11 2006 - 20:27:04 CEST

Original text of this message