Archives of the TeradataForum

Message Posted: Mon, 27 Nov 2006 @ 23:23:44 GMT

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

My swag is that the coalesce is generating an integer since the value when null is integer 0, sort of like a union all statement takes the data type from the first select clause.

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