concat two strings

Jürg Schaufelberger · *nix forums beginner Joined: 15 Sep 2005 Posts: 4

Hello

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

Mark C. Stock · *nix forums Guru Joined: 05 May 2005 Posts: 730

"Jürg Schaufelberger" <juerg.schaufelberger@tele2.ch> wrote in message
news:mlL8g.169$OK3.41@nntpserver.swip.net...
: Hello
:
: 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
:
:

look into case, nvl, nlv2, and decode

some combination of one or two of these should work for you

++ mcs

Google