Archives of the TeradataForum
Message Posted: Thu, 03 Nov 2005 @ 11:12:04 GMT
I am populating a column by converting decimal(16, 0) into varchar(18) as below.
A boring trailing dot will appear if I simply use trim(col1).
The issue is that some of the 'col1' values go beyond the Teradata max integer limit. So I cann't discard the trailling dot by this way.
Has anyone faced this issue before? Any resolutions are welcome.
Thanks in advance,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|