Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 19 Dec 2006 @ 11:42:21 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Char2Hex and Vice-Versa
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, December 19, 2006 04:39 -->

Hi All

It would be of great help if you could help me to know how to frame the SQL for Conversion from Hex to Char.

I do know how to convert a string value from Char to hex and vice - versa

     -- 54657374

     Sel '54657374'XC
     -- Test

But If I insert the string into a table as a hex how do I get the value back from the table ..

     Create table Hexcon
       Col1 varchar(30)
     Insert into Hexcon
     Sel col1 from Hexcon
     -- 54657374 ;

I need to convert this Hex to its original ASCII value 'Test' how to do this ?...

I am able to do the same using a Stored procedure by reading the value from the table one by one and converting it into ASCII value and inserting into another table. But this is very slow.. Is there any other way thru SQL alone.

Thanks for your help

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