|
Archives of the TeradataForumMessage Posted: Wed, 03 Aug 2005 @ 09:17:44 GMT
Thanks for the suggestion but what i really want is 1) If we have a numeric datatype whose precision is dynamic mean to say it can be of type Numeric(10,4) or Numeric(18,8) and get the values in varchar. For eg : if the value in the numeric column of (10,4) is 123.45 then the resultant should be 123.45 not 123.4500 and if the value was 125 then the resultant should be 125 and not 125.0000. The problem here is since the precision is dynamic, what i can do is trim(cast(column as varchar(18))). Regards Alexander
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||