Archives of the TeradataForum

Message Posted: Thu, 07 Oct 2004 @ 10:28:24 GMT

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

Try this ,

     coalesce(b.cr_risk_clasfn_chng_dt, CURRENT_DATE) as
     cr_risk_clasfn_chng_dt

Regards,

Rehman ,
Singapore.

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