I asked this last week, but I need to revisit it.

I have a table with 25 columns named 'upsell1_count' through 'upsell1_count'.
The columns allow nulls.

What I have now is:

select ISNULL( upsell1_order_count , 0) + ISNULL( upsell2_order_count , 0) + 
       ISNULL( upsell3_order_count , 0) + ISNULL( upsell4_order_count , 0) + 
       ISNULL( upsell5_order_count , 0) + ISNULL( upsell6_order_count , 0) + 
       ISNULL( upsell7_order_count , 0) + ISNULL( upsell8_order_count , 0) + 
       ISNULL( upsell9_order_count , 0) + ISNULL( upsell10_order_count , 0) + 
       ISNULL( upsell11_order_count , 0) + ISNULL( upsell12_order_count , 0) + 
       ISNULL( upsell13_order_count , 0) + ISNULL( upsell14_order_count , 0) + 
       ISNULL( upsell15_order_count , 0) + ISNULL( upsell16_order_count , 0) + 
       ISNULL( upsell17_order_count , 0) + ISNULL( upsell18_order_count , 0) + 
       ISNULL( upsell19_order_count , 0) + ISNULL( upsell20_order_count , 0) + 
       ISNULL( upsell21_order_count , 0) + ISNULL( upsell22_order_count , 0) + 
       ISNULL( upsell23_order_count , 0) + ISNULL( upsell24_order_count , 0) + 
       ISNULL( upsell25_order_count , 0) as upsell_total 
  from result_detail

Is there a cleaner way to do this?