Archives of the TeradataForum

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

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

You are right the book is wrong, go figure. If you do the following, it works:

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

So I would try surrounding each coalesce with () and see if that helps

Kevin R Tewksbury
Sr. Database Administrator
LimitedBrands
Limited Technology Services

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