Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 14 May 2004 @ 20:07:06 GMT

  <Prev Next>  
Next> Last>>  

Subj:   ByteInt within Character String
From:   tklamt

I have a peculiar requirement. I have a single byte binary value stored in the middle of a string. I need to retrieve that value and store the number in a table using SQL.

Most of the time, the value is not considered a numeric value and therefore fails during conversion to the target SMALLINT column.

I've tried multiple levels of CASTing with no success. It seems that the only way to do this job is with a CASE construct, with 256 possibilities. Like this:

     WHEN X'00' THEN 0
     WHEN X'01' THEN 1
     WHEN X'02' THEN 2
     WHEN X'FF' THEN 255

Any other ideas?

Thanks to all. TK

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