Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 07 Dec 2004 @ 09:34:06 GMT


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


Subj:   Numeric to string Conversion and a single column
 
From:   Jebaseelan_S

Hi All ,

Sel '1','2','4','3','5',',6','7','8','9' will give a Nine column output.

But I want them in a single column like a string .. "'1','2','4','3','5',',6','7','8','9' "

TD doesn't have replace function so that I can take out the " ' " and select as a string ..

Is there any way to get this in Teradata ?

I cannot do concat as the Input I get is from a variable and of the format 'x','y','z'...


Thanks

Jebaseelan
DELL Inc



     
  <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