Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Sep 2005 @ 20:53:37 GMT


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 


Subj:   Teradata equivalent of TRANSLATE
 
From:   Raghav Vaidya

I need to convert a piece of DB2 code to Teradata. The code is something like this:

     CASE WHEN
     TRANSLATE(RTRIM(LTRIM( SUBSTR(COL_1,1,6) )),'$',' 0123456789')
     = '' THEN INTEGER(SUBSTR(COL_1,1,6)) ELSE CAST(NULL as  INTEGER)
     END AS DISP_COL_1

What does the TRANSLATE on DB2 do ?. What would be the Teradata equivalent for this ?.

Sorry, this may be very basic, but I cannot understand what the TRANSLATE on DB2 does to look for a solution on Teradata.


Thanks in advance !

Raghav Vaidya



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