|
|
Archives of the TeradataForum
Message Posted: Wed, 06 Dec 2006 @ 17:06:39 GMT
Subj: | | 3706: Syntax error: expected something between ')' and '+' |
|
From: | | LEWIS, JOHN |
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
| |