Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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'...



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