Archives of the TeradataForum

Message Posted: Wed, 09 Oct 2001 @ 20:09:39 GMT

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

My first question is: are they allows leading zeroes?

If so, define the leading zeroes as junk char(??). Then, define the good data as a DECIMAL(??) and use it for the PI data for each row. Remember to ignore the junk.

If this (leading zeroes) is not the case, define it as two separate fields. Then, multiply the first field by 10000?? (whatever to account for digits) and add the two fields together. This is how Teradata handles a date for combining hours, minutes and seconds.

the problem here is that you might end up with a DECIMAL larger than 18 digits.

Best of luck,

Mike

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