Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 31 Mar 2005 @ 18:33:11 GMT

  <Prev Next>   <<First <Prev

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.


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023