How do I compute for the total of the value in Alias vladd1, vladd2, vladd3, vladd...

Question

Hi,

How do I compute for the total of the value in Alias vladd1, vladd2, vladd3, vladd4 or any alternative using declare statement ? Here is my sample statement below.

                    
select alan8,                      
case                       
when rtrim(aladd1)  '' then len(aladd1) + 9 else 0 end as vladd1 ,                      
case                      
  when rtrim(aladd1)  '' then len(aladd2) + 9 else 0 end as vladd2 ,                      
case                      
  when rtrim(aladd1)  '' then len(aladd3) + 9 else 0 end as vladd3 ,                      
case                      
  when rtrim(aladd1)  '' then len(aladd4) + 9 else 0 end as vladd4,                      
vladd1 + vladd2 + vladd3 + vladd4 as Total                      
 from Customers

Thanks and appreciate your help.

Regards, cyberarent2

Answer 1

0

Something similar to this?

select  	alan8,            
    	sum(case when aladd1 > '' then len(aladd1) + 9 else 0 end) as vladd1,            
    	sum(case when aladd2 > '' then len(aladd2) + 9 else 0 end) as vladd2,            
    	sum(case when aladd3 > '' then len(aladd3) + 9 else 0 end) as vladd3,            
    	sum(case when aladd4 > '' then len(aladd4) + 9 else 0 end) as vladd4,            
    	SUM(len(aladd1) + len(aladd2) + len(aladd3) + len(aladd4) + 36) as Total            
from    	Customers             
group by    alan8

answered Nov 23 '09 at 04:51 AM

Peso
1.6k ● 4 ● 6 ● 8

(comments are locked)

How do I compute for the total of the value in Alias vladd1, vladd2, vladd3, vladd...

Follow this question

Related Questions