Archives of the TeradataForum

Message Posted: Wed, 02 Jul 2003 @ 21:58:38 GMT

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

You can use COALESCE for each date to eliminate NULLs:

min(coalesce(t1.date1, cast( '19000101' as date format 'YYYYMMDD') ) ,
.......

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