![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Tue, 05 Dec 2006 @ 14:26:50 GMT
Subj: | | Re: Handling 21 digits in Teradata |
|
From: | | Stone, Randall |
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
| |