Archives of the TeradataForum

Message Posted: Tue, 10 Oct 2006 @ 14:15:08 GMT

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

Rao

Your input string is 20 bytes long and your output data type allows for 17 digits in total. I appreciate that there may be decimal points and positive / negative signs embedded in the text, bringing the max number of printable chars to 19.

I suspect that you may have additional characters in your table. In order to identify if you have any, you could try the following:

     select
     substr(TableData,48,20)(Decimal(17,2))  b
     from prododss.GTSTableData
     where TableCode = '00842'

     where substr(TableData,48,20) (float) > '999999999999999999' (float) /*18 9s */
     ;

This may show you if there are are any values in your data that you did not expect.

Hope this helps

Frank

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