Archives of the TeradataForum

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

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

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>>