Archives of the TeradataForum

Message Posted: Wed, 03 Aug 2005 @ 09:17:44 GMT

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

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

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