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

normalize the table and uses SUM()