Archives of the TeradataForum

Message Posted: Fri, 26 Nov 2004 @ 19:45:40 GMT

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

Thanks for all the replies.

The solution that we went for in the end was to put out an indicator out before each of the nullible decimal fields

     Select
      col1
     ,case when decimal_field is null then '?' else ' ' end
     ,decimal_field
     ,col3
     ,col4
     from my_table;

The load utility is then able know which decimal fields are nulls and can load them accordingly.

Thanks

Fachtna

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