Archives of the TeradataForum

Message Posted: Wed, 23 Jan 2008 @ 13:53:47 GMT

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

I recall many, many moons ago operating on each digit of the input attribute via a case statement that built up the number as the sum of pos1 * 100,000,000 + pos2 * 10,000,000 etc. The case statement assigned zero to null columns.

If you have leading zeros then the need for a case statement went away.

I also recall using a REDEFINES statement or its equivalent in the MLoad Script to put everything together as one named variable.

Does this ring true?

Rgrds,

Bill Gregg

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