Bonnie,

Thank you for the reply. I am using SQL Server and I had thought about your suggestion, but the calculations are more complicated than the exmaple I gave. So it would be a lot cleaner if I could use the calculated results.

Kind Regards,

Mat

>Mat,
>
>I'd say it depends on what database you're using. SQL Server does not support this type of syntax, but I don't know about other databases (like maybe Oracle). BTW, for the particular example you gave, you could always do something like this instead:
>

>select sum(jan+feb+mar) as qtr1,
>       sum(apr+may+jun) as qtr2,
>       sum(jan+feb+mar+apr+may+jun) as first6months
>  from myTable
>

>
>
>~~Bonnie
>