Archives of the TeradataForum
Message Posted: Thu, 31 Mar 2005 @ 18:33:11 GMT
| Subj: || || Re: Convert hex number to int? |
| From: || || Victor Sokovin |
| ||i had the same problem, i created a lookup table. first column with hex string, secound with the integer value.|| |
| ||maybe not the best way regarding performence but easy to implement.|| |
It could be easily the fastest method as well. Substring manipulations have never been exceptionally fast. Of course, we don't know how many
"integers" the OP needs to prepare. It could be what TD refers to as small integer, or the 4-byte integer, or perhaps *any* integer on the planet.
In the latter case your method won't work.
Anyway, I think there have been quite enough suggestions made so far. The exact implementation could belong in the billable department, if
there is still such a thing left somewhere. Not that I discourage further postings to this thread, of course.