Archives of the TeradataForum

Message Posted: Wed, 06 Dec 2006 @ 18:51:17 GMT

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

It's a parser problem:

You have to use brackets for CASE/COALESCE/NULLIF, if there's any additional opration.

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

     SELECT (COALESCE(100,0)) * 100;

Dieter

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