Archives of the TeradataForum

Message Posted: Wed, 06 Dec 2006 @ 17:06:39 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Receiving the following error when using COALESCE with an arithmetic operator:

     SELECT
        (coalesce(cnt_2_9, 0) + coalesce(cnt_30_59, 0) +
     coalesce(cnt_60_210, 0)) AS TOTAL,
        CURRENT_TIMESTAMP
     FROM table_a;

According the Teradata manual, the following should work but does not:

     SELECT COALESCE(100,0) * 100;

Any help would be greatly appreciated.

Thanks

John

	<Prev	Next>		<<First	<Prev	Next>	Last>>