Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 14:20:33 GMT

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

<-- Anonymously Posted: Thursday, March 13, 2003 08:58 -->

Try this

CASE WHEN VPIL.PO_DLVRY_DUE_DT IS NOT NULL
     THEN VPIL.PO_DLVRY_DUE_DT
     ELSE CAST ('1900-01-01' AS DATE)
END                        AS PO_DLVRY_DUE_DT

Thanks & Regards

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