Archives of the TeradataForum

Message Posted: Fri, 24 May 2002 @ 17:01:03 GMT

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

Geoffrey:

You might try something like the following:

sel cast( (floatcol/100 (format '9(18)')) as char(18)) || cast( ((floatcol mod 100) (format '99')) as char(2)) from float_table;

I experimented with it a litte and it seems to work.

Regards,

Mike

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