Archives of the TeradataForum

Message Posted: Fri, 26 Oct 2012 @ 19:03:46 GMT

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

Sughesh-

For UNIONs, the data type and size of the columns in the resulting data set is determined by the column definitions in the first query of the UNION.

You will need to CAST the columns to support the larger value.

-dave.clark

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