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.


     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.


  <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