Archives of the TeradataForum

Message Posted: Tue, 05 Dec 2006 @ 14:26:50 GMT

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

Duh, I should have thought of that. (_:(|) D'oh!

Still, I still don't see why he couldn't break the string in half to do the math. I had to do the same thing with a SQL Server ap because SQL Server couldn't do math on anything longer than 4 bytes and I had an 8 byte hex number I needed to do math on. So I converted it to a varchar variable, broke it in half, did the math on both halves as appropriate, converted the halves back to varchar, concatenated them, and then converted back to numeric before inserting back into the table.

Randall

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