Concat function [message #317458] |
Thu, 01 May 2008 08:43  |
shoaib123
Messages: 118 Registered: December 2007 Location: Chicago
|
Senior Member |
|
|
(a.last_name||'#'||b.first_name|| '#'||c.middle_name)
I am concatenating three columns as above and seprating them with '#'. There are some values which are null in those columns, for that i want to skip '#'. so, if there is null value, i want to keep that as blank.
Thanks and Appreciate your time in advance
|
|
|
|
Re: Concat function [message #317470 is a reply to message #317461] |
Thu, 01 May 2008 09:05   |
shoaib123
Messages: 118 Registered: December 2007 Location: Chicago
|
Senior Member |
|
|
Thank Michel for you time.. I am trying to explain my question again. Or i will really appreciate if you can help with some more details.
Use NVL:
nvl((a.last_name||'#'||b.first_name|| '#'||c.middle_name)
,' ')
Even though all three columns are null in some cases.. It's going to add '#' anyway. So, for the null values the data will look like this
So,if it finds any null value on those columns, i don't want to add '##'.
Appreciate you time once again
|
|
|
|
|