Archives of the TeradataForum

Message Posted: Mon, 02 Aug 2004 @ 22:02:42 GMT

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

Thanks James. I fixed the other error .

So to remove the unpredictable character unprintable character, How should I turn the Hex on? or how to include '0A'.

Is the following syntax right for the HEX?

     .FIELD "atl_time_dfnt_avg_wt_hvy_shipm" * VARCHAR(22) nullif
     "atl_time_dfnt_avg_wt_hvy_shipm"='0000000000000000000000'x;

Thanks.

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