Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Jul 2004 @ 15:16:53 GMT


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


Subj:   Re: Changing a column name while concatinating
 
From:   Nomula, Madhukar

I have 20 case statements to concatinate and i am using the result of one case statement in other. This is the reason i am renaming a case statement. In the query i am renamed the 1st case statement into new_custid, which i am using in the second case statement and so on. The problem is i can not concatinate and rename that column, irrespective of whether i am using case statement or not. For example the following querys is also giving me an error.

     select customername NEW_CUST_NAME || custid from customer.

or

     select customername as NEW_CUST_NAME || custid from customer

Both the above queries are not working. Is there a way to get the above querys working. I am renaming the customername to use it down the line.


Mad.



     
  <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: 23 Jun 2019