On Tue, Feb 25, 2003 at 15:25:17 +0100, Natasa Bulatovic <n.bulatovic@zim.mpg.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
statementdoes 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.