On Tue, Feb 25, 2003 at 15:25:17 +0100,
Natasa Bulatovic <n(dot)bulatovic(at)zim(dot)mpg(dot)de> wrote:
>
> select col1||col2||col3||.....||col100 from table
>
> Most of these columns for the test data are NULL...Datatypes of columns are mixed text, varchar, char...Select statement does not return any error...Just returns a row with a null result....
If you concatenate null with another string you get null, not the other string.
You need to use coalesce to convert nulls to empty strings.